Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: INSERT INTO Clause problem
01-28-2005, 04:37 AM #1
- Join Date
- Jan 2005
- Thanked 0 Times in 0 Posts
INSERT INTO Clause problem
I have a function for inserting new data into a table but I'm receiving the following error:
Server Error in '/Contractors' Application. Insert Error: Column name or number of supplied values does not match table definition. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Insert Error: Column name or number of supplied values does not match table definition. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
I'm not completely sure if I'm supposed to use the Param's for INSERT INTO clause, but here is the function I'm calling thats causing the error:
Private Sub cmdAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdAdd.Click 'Save the values from the details fields to the database conn.Open() Try Dim updAdd As SqlCommand = New SqlCommand("INSERT INTO Contacts VALUES (@VendorNo, @DateIssued, @Surname, @FirstName, @ContactNumber, @Address)", conn) With updAdd.Parameters .Add("@VendorNo", txtAddVendorNumber.Text) .Add("@DateIssued", txtAddDateIssued.Text) .Add("@Surname", txtAddSurname.Text) .Add("@FirstName", txtAddFirstName.Text) .Add("@ContactNumber", txtAddContactNumber.Text) .Add("@Address", txtAddAddress.Text) End With updAdd.ExecuteNonQuery() Finally conn.Close() End Try End Sub