Querying a dataset
Posted on 2006-05-14
I am using a dataset to hold a whole lot of entries for a competition then I use a randon number to select which row won what I then want to do is update the dataset by removing all instances of the winners phone number as I need to choose more than one winner and don't want to return the same user more than once. I could loop thorugh all the rows deleting it if it has that number but that seems very time consuming. Is there a way to remove rows with a query?
Also I am populating the dataset using a SqlDataAdapter if I do remove rows from the dataset that will not delete anything from the original tables in the database correct?