hello to all,
i got a problem in vb.net program, i dont how to delete multiple rows in a single table i used "truncate" command.
this is my code for deleting:
Private Sub tranc()
Try
Dim dbconn As OleDbConnection
Dim dbcom As New OleDbCommand
dbconn = New OleDbConnection(cnnstring())
dbcom.CommandText = "TRUNCATE FROM [PartDisc_table]"
dbcom.Connection = dbconn
dbcom.Connection.Open()
dbcom.ExecuteNonQuery()
dbcom.CommandText = "TRUNCATE FROM [Distribution_table]"
dbcom.Connection = dbconn
dbcom.Connection.Open()
dbcom.ExecuteNonQuery()
dbconn.Close()
dbcom.Dispose()
Catch ex As Exception
MsgBox(ex.Message, MsgBoxStyle.Critical, "General Error")
End Try
End Sub
i used access database on it.
when i run my prog. i got this error "Invalid SQL statement; expected 'delete','insert.... or 'update'.
i will appreciate for any help.