I want to discuss about c# search in Data Table
Search DataTable by Column Name:
Example:
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:
1 2 3 4 5 6 |
DataTable dTable ; DataView dv = dTable .DefaultView; dv.RowFilter = "parentcode=" + code + ""; dv.Sort = "code desc"; |
Then copy dataview to datatable:
1 |
dTable = dv.ToTable(); |
Another way, If you want only datarow then try this:
1 |
DataRow[] drs = dt.Select("(parentcode = " + code + ")"); |