Filter or select specific rows from datatable or dataset

DataTable.Select() will filter the rows based on the filter expression.

dt.Select("State='Andhrapradesh'") will return the rows which is having state = 'Andhrapradesh'

Source Code:
DataTable dt = new DataTable("ResultSet"); dt.Columns.Add("Country"); dt.Columns.Add("State"); dt.Columns.Add("Place"); dt.Rows.Add("India", "Andhrapradesh", "Charminar"); dt.Rows.Add("India", "Andhrapradesh", "Steel Plant"); dt.Rows.Add("India", "Maharastra", "IT Hub"); dt.Rows.Add("India", "Tamilnadu", "Beach House"); dt.Rows.Add("India", "Tamilnadu", "Club House"); dt.Rows.Add("USA", "Dallas", "Airport"); dt.Rows.Add("Australia", "Sydney", "Stadium"); DataRow[] arydr = dt.Select("State='Andhrapradesh'"); DataTable dtStates = dt.Select("State='Andhrapradesh'").CopyToDataTable();

Output of DataTable dtStates = dt.Select("State='Andhrapradesh'").CopyToDataTable();