Deleting all records in a table

[csharp_boy]

Hi

at the moment, Im trying to delete all records in a table.

(1) What i do is create a dataAdapter that drags out all records and fill it into a dataset.
(2) go through each record in the dataset, and mark it as Delete
(3) Update the Database using Update from the Data Adapter.

This method seems rather slow and inefficient.

I was wondering is there another way of deleting all rows in a table without having to populate a dataset?

thanks

 

[csharp_boy]

figured it out!

that was easy. i feel stupid to have asked.

u dont use dataadapter, instead u go


conn.Open();
OleDbCommand deleteAll = new OleDbCommand("Delete from Table1", conn);
deleteAll.ExecuteNonQuery();
conn.Close()

 

[Joe Mamma]

figured it out!

that was easy. i feel stupid to have asked.

u dont use dataadapter, instead u go


conn.Open();
OleDbCommand deleteAll = new OleDbCommand("Delete from Table1", conn);
deleteAll.ExecuteNonQuery();
conn.Close()

note. . . this will populate the log and could impede performance.
In sql server you have the "truncate" statement. in other databases, there is probably a similar statement

just an fyi