Reply to thread

Message

<blockquote data-quote="jlwilliams1" data-source="post: 5864" data-attributes="member: 2322">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(&quot;tablename&quot;).Rows.Clear(), but neither seems to work. Any clues or ideas?Here's the code I'm using:[CODE] SelectStatement = &quot;SELECT * FROM Test WHERE Newrecord = 'Y'&quot; cmd.CommandText = SelectStatementcmd.CommandType = CommandType.Textcmd.Connection = connectda.SelectCommand = cmdconnect.Open()ds.Clear()da.Fill(ds, &quot;Test&quot;)If ds.Tables(0).Rows.Count &lt;= 0 Thenda.SelectCommand.Connection.Close()Exit SubEnd Ifconnect.Close()numrecs = ds.Tables(0).Rows.Count[/CODE]</blockquote>

[QUOTE="jlwilliams1, post: 5864, member: 2322"] 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? Here's the code I'm using: [CODE] SelectStatement = "SELECT * FROM Test WHERE Newrecord = 'Y'" cmd.CommandText = SelectStatement cmd.CommandType = CommandType.Text cmd.Connection = connect da.SelectCommand = cmd connect.Open() ds.Clear() da.Fill(ds, "Test") If ds.Tables(0).Rows.Count <= 0 Then da.SelectCommand.Connection.Close() Exit Sub End If connect.Close() numrecs = ds.Tables(0).Rows.Count [/CODE] [/QUOTE]

Verification