Using Dataset.Clear() to clear an SQL-database

[Cub71]

Is it possible to use

dataset.Clear();
dataAdapterSomething.Update(dataset.table);

to clear a table in an SQL database?

I am not able to get this to work. The dataset clears, but the changes
are not updated into the database.

 

[Marina Levit [MVP]]

You would have to mark each row for deletion. Clearing the dataset
physically removes all the rows.

 

[Guest]

Just use a SqlCommand to run either
Delete From TableName
if the table is referenced by foreign key constraints.
If it isnt:
Truncate Table TableName

Truncate also resets Identity columns whereas delete doesnt.

Ciaran O'Donnell

 

[Cub71]

Ciaran O''Donnell skrev:

Just use a SqlCommand to run either
Delete From TableName

Thank you. That is what I ended up doing.