Clearing a dataset?

[jlwilliams1]

I'm writing a windows service that periodically goes out to a SQL table and checks it for new records. I connect ok and fill the dataset ok, but how do I clear the dataset once I'm done with it? What's happening is that evertime the service goes to check the table, it fills the dataset, appending from the end. So if I start with 2 new records in the dataset, at the next check the dataset will have 4, then 6, etc.

 

I've tried using dataset.clear and dataset.Tables("tablename").Rows.Clear(), but neither seems to work.

 

Any clues or ideas?

[eramgarden]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdatadatasetclasscleartopic.asp

 

see if that helps