Monday, April 19, 2010

Filter Rows from Dataset

Filter Rows from dataset

Step - 1 Convert Datatable to Dataview

DataTable dt = ViewState["MyDataTable"] as DataTable;
DataView dvMyDataTable = dt.DefaultView;

Step - 2 Apply filter conditions in dataview

dvMyDataTable.RowFilter = "DatatableField_Name = " + "My Name";

Step - 3 save data after filter

dt.AcceptChanges();

No comments: