I am currently working on a project in which i've used the DataSet (.xsd) things (are they controls objects ). I then bind these to a GridView via the DataSource associated with the GridView. Easy peasy.
This works fine so far, as where I have used this method I have only needed to show all rows from the tables i'm using (SELECT * FROM nef_groups).
Now however, I need to return only some records (SELECT * FROM nef_groups WHERE group_key = 2). This value will come from a querystring.
How would I pass this querystring value into the DataSet query Is there a better way to achieve what I want It's fairly important that the rows returned end up in a GridView to maintain continuity, where the column headings can be used for sorting etc.
Thanks for any help,
Dave.