Datatable dt = new Datatable ();
Datatable dtFilter = new Datatable ();OleDbDataAdapter oleda = new OleDbDataAdapter();
oleda.SelectCommand = cmd;
oleda.Fill(dt); //(Here you can Fill your datatable)
DataView dvRejFile = new DataView(dt);
//now you can filter the dataview using Row filter
// Column Name Value
dvRejFile1.RowFilter = "[Application No] <> '" + Pass your value+ "'";
// Assign your filter dataview to another datatable.
dtFilter = dvRejFile.ToTable();
No comments:
Post a Comment