how do I implemet a parameter for my INSERT statement.
i know that I use the following for an UPDATE, but cannot find any info on how to do the insert.
this is my update code:
sql = "update tblClients set ClientFirstName= @ClientFirstName, ClientLastName= @ClientLastName, ClientMiddleName= @ClientMiddleName where ClientId= @clientID"
Dim command As New OleDbCommand(sql, conn)
command.Parameters.AddWith
Value("@Cl
ientFirstN
ame", txtFirst.Text)
command.Parameters.AddWith
Value("@Cl
ientLastNa
me", txtLast.Text)
command.Parameters.AddWith
Value("@Cl
ientMiddle
Name", txtMiddle.Text)
command.Parameters.AddWith
Value("@Cl
ientId", _clientID)
thank you
Start Free Trial