data table filter

Question

I have a data table named it as dt.The table containts Three rows .I want to filter the data table and append the data after filtering to a grid view please suggest some ideas.

Amit Gupta · Answer

You can create a copy of datatable and merge with existing table to append the result to gridview. var dt= newDataTable(); //assuming dt is filled with rows Gridview.DataSource=dt;// till now you had done //creating copy and apply filter var dt1=dt.Copy ().DefaultView; dt1.RowFilter =name = tony; //your filter criteria //now merge the tables and it will reflect the result in your gridview. dt.Merge ((DataTable)dt1); Thats all you have to do. Hope it helps

Manas Mohapatra · Answer

Try with below code: DataTable playerTable = new DataTable( Players ); playerTable.Columns.Add( new DataColumn( ID  typeof ( int ))); playerTable.Columns.Add( new DataColumn( Name  typeof ( string ))); playerTable.Columns.Add( new DataColumn( DOJ  typeof (DateTime))); playerTable.Columns.Add( new DataColumn( Country  typeof ( string ))); playerTable.Columns.Add( new DataColumn( IsActive  typeof ( bool ))); playerTable.Rows.Add(1 Sourav Singh  DateTime.Now India  true ); playerTable.Rows.Add(2 Simon David  DateTime.Now England  true ); playerTable.Rows.Add(3 Chris Brown  DateTime.Now WestIndies  true ); playerTable.Rows.Add(4 Manas Nayak  DateTime.Now India  true ); playerTable.Rows.Add(5 John Lee  DateTime.Now England  true ); playerTable.Rows.Add(6 Salim Desmukh  DateTime.Now India  false ); playerTable.Rows.Add(7 N Patil  DateTime.Now India  true ); playerTable.Rows.Add(8 Ricky Samson  DateTime.Now England  false ); DataRow[] result = playerTable.Select( ID >= 2 AND IsActive = true ); foreach (DataRow row in result) { Console.WriteLine( {0} {1}  row[0] row[1]); } http://www.c-sharpcorner.com/article/more-on-c-sharp-datatable/