C# Archives | Programming71.com

I want to discuss about c# search in Data Table Search DataTable by Column Name: Example:

string _sqlWhere; _sqlWhere = "PROD_NAME like '" + strProductName + "%' and BOM_CATEGORY_ID in (" + strBomCategory + ")"; 
DataTable _newDataTable = dt.Select(_sqlWhere).CopyToDataTable();

1 2	string _sqlWhere; _sqlWhere = "PROD_NAME like '" + strProductName + "%' and BOM_CATEGORY_ID in (" + strBomCategory + ")"; DataTable _newDataTable = dt.Select(_sqlWhere).CopyToDataTable();

You can search group of value from datatable using DataView . First create dataview from datatable. And then Filter in dataview by column name and order by. Example:

DataTable dTable ;

DataView dv = dTable .DefaultView;

dv.RowFilter = "parentcode=" + code + "";
dv.Sort = "code desc";

DataTable dTable ;

DataView dv = dTable .DefaultView;

dv.RowFilter = "parentcode=" + code + "";

dv.Sort = "code desc";

Then copy dataview to datatable:

dTable = dv.ToTable();

1	dTable = dv.ToTable();

Another way, […]