How do I delete all the records from a table

[tango1948]

Hi
I have the following code:

Try
  With tblUser_adapter
      .FillSchema(ds, SchemaTyped.Mappde, "tblUser")
      .Fill(ds, "tblUser")
      .DeleteCommand.CommandText = "delete from tblUser"
      .Update(ds, "tblUser")
  End With
Catch ex as Exception
  MessageBox.Show(ex.Message)
End Try

What do I need to add to delete all the records from tblUser?

Thanks for any help

David

 

[SHelton]

The easist and quickest way is to not bother loading the data at all. You can do this with a SqlCommand object using DELETE FROM tblUser as the CommandText.

 

[chrissie1]

and then do executenonquery.

Christiaan Baes
Belgium

"My old site" - Me

 

[tango1948]

Hi,
Thanks for the replies I'll do as you suggest.
As a matter of intrest what's missing in my code, deleting all the records is not a good example, but if I want to update records in a table or delete only some records what do I need to add to the code above.

Thanks


david