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, […]