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.

"Cub71" <bj*****@gmail.comwrote in message
news:11**********************@h54g2000cwb.googlegr oups.com...

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.

[Ciaran O''Donnell]

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" wrote:

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.

[Cub71]

Ciaran O''Donnell skrev:

Just use a SqlCommand to run either
Delete From TableName

Thank you. That is what I ended up doing.