Deleting all records in a table

[csharp_boy]

Hi

 

at the moment, I'm 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 don't 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 don't 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