DataTable dt = new DataTable(); dt.Columns.Add(new DataColumn("Group", typeof(int))); dt.Columns.Add(new DataColumn("name", typeof(string))); DataRow dr = dt.NewRow(); dr["Group"] = 1; dr["name"] = "Apple"; dt.Rows.Add(dr); dr["Group"] = 2; dr["name"] = "Milk"; dt.Rows.Add(dr); dr["Group"] = 1; dr["name"] = "Orange"; dt.Rows.Add(dr); dr["Group"] = 2; dr["name"] = "Curd"; dt.Rows.Add(dr);
DataRow[] dr1 = dt.Select("group in (1,2)");
DataView dv = dt.DefaultView; dv.RowFilter = "group in (1,2)"; dt = dv.ToTable();
can we use "dt.Select("group <b>not</b> in (1,2)")"?????
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)