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/