Binding to a filtered DataTable

[Rob]

If I apply a FilterExpression to a DataTable's DefaultView, if I want to see only the filtered rows in my grid should I bind to DataTable.DefaultView or can I just bind to the DataTable and get the same result?

[Shinu]

Hi Rob,

Since you are setting the filter expression to the DataTable's DefaultView you can bind the DefultView as the DataSource for the Grid to show the filtered data in Grid.

CS:

            conn.Open();
            string selectQuery = "SELECT ProductID,ProductName,SupplierID FROM Products";
            adp.SelectCommand = new SqlCommand(selectQuery, conn);
            DataTable dtTable = new DataTable();
            adp.Fill(dtTable);
            DataView dv = dtTable.DefaultView;
            dv.RowFilter = "ProductName='Aniseed '";
            RadGrid1.DataSource = dv;
            conn.Close();

Thanks
Shinu.