N
Neuxs
I want to add a new record (i.e. new vendor) into the
table. I have tried using the Insert Command but it
doesn't insert the record into the SQL table. Or is there
any other ways to add a new record? Below are the codes
that I have typed in.
--- Codes ---
cmdInsert.CommandText = "Insert INTO " _
& "tblVendors(VendorID)" _
& "VALUES(@VendorID)"
cmdInsert.Parameters.Add("@VendorID", SqlDbType.Int, 4,
txtVendorID.Text)
table. I have tried using the Insert Command but it
doesn't insert the record into the SQL table. Or is there
any other ways to add a new record? Below are the codes
that I have typed in.
--- Codes ---
cmdInsert.CommandText = "Insert INTO " _
& "tblVendors(VendorID)" _
& "VALUES(@VendorID)"
cmdInsert.Parameters.Add("@VendorID", SqlDbType.Int, 4,
txtVendorID.Text)