Clearing a dataset?

[jlwilliams1]

Im 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 Im done with it? Whats 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.

Ive 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/d...tml/frlrfsystemdatadatasetclasscleartopic.asp

see if that helps