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?
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);