I am having trouble trying limit the rows returned in a datagridview. Everytime I try to use it, it only returns the whole table. I just want to limit it to certains rows based on values in a column.
I have tried to alter the SQL but to no avail. During setup the datasource always seems to default to a whole table.