refresh dataset from database

[mcerk]

Hi. I use dataset only to display data. I do updateing with executing INSERT SQL statement with

myCommand.ExecuteNonQuery()


ok.

But after I insert data, I need to refresh dataset, to display correct content.

How can I do this, and - is it ok if I do so, or do I have to change methods?

tx

matej

 

[Derek Stone]

You would refresh the data using the same exact method you used to retrieve the data in the first place.

 

[mcerk]

yes, but if I do OleDbConnection.Fill(dataset)
then dataset got filled again (previous data is not cleared).

so I need to clear it first. how can I do this?

 

[cpopham]

dataset.clear() should do it...

Chester