adding records to access database

[robbie_62]

hi there

Ive managedd to connect to an access database in vb.net
how do I go about adding records in code ???

 

[Robby]

I dont know the context of what youre doing, but one common way is to use OleDbCommand with the method .ExecuteNonQuery(). This would use the Delete statement...

con is your connection string

Dim recordsAffected As Integer
dim sSql as string = "DELETE ID FROM myTable WHERE ID = " & SomeIntegerVar

Dim cmd As OleDbCommand = New OleDbCommand(sSql, con)
cmd = New OleDbCommand(sSql, con)
recordsAffected = cmd.ExecuteNonQuery()