Clearing or Deleting a Dataset.

[byoung]

I know it is probably obvious, but I tried dataset.Tables(TableName).Dispose(), but it doesn't clear or delete the table by name.

 

The next fill with the same tablename adds to the end of the dataset.tables(TableName).

 

How do I Clear or Delete a dataset's Table?

 

Barry

Edited January 28, 2003 by byoung

[Nerseus]

You want to use Clear() if you're trying to remove the *rows* from the DataTable. If you want to clear them from database, you'll need to Delete() them and then call the DataTable (or DataSet's?) Update() method.

 

Dispose is a .NET mechanism for cleaning up resources on objects. You'll pretty much never use it on a DataSet, DataTable, etc.

 

-nerseus