Adding data to a Database

g_dub96 · October 8th, 2003, 12:42 PM

I am having a small problem I am trying to add data to my database on my local SQL Server. I inserted this Try...Catch... Statement in my code to find the problem.

Code:

Code'Execute the SqlCommand object to insert the new data... 
Try 
            objCommand.ExecuteNonQuery() 
        Catch ex As Exception 
            MessageBox.Show(Err.Description) 
        End Try

And it gives me an error message saying Incorrect Syntax near 'nvarchar' must declare the variable @Annual

Code:

'set the SqlCommand object properties... 
        objCommand.Connection = SqlConnection1 
        objCommand.CommandText = "INSERT INTO Demo " & _ 
        "(Address, [Annual Income], [Case Number], [Estimated Cost], [First Name], ID, [Last Name], Status)" & _ 
            "VALUES (@Address, @Annual Income, @Case Number, @Estimated Cost, @First Name, @ID, @Last Name, @Status);":

To my understanding if I put a @before my column name it acts like a placeholder for data that will be inserted by the SqlParameter objects in the parameters collection?

So if anyone can see the problem please help me out.

planoie · October 8th, 2003, 04:22 PM

"@abc" represents a variable to SQL. You are problably having a problem because you have split var names.

You should try to stick with non-spaced names for vars:
...VALUES (@Address, @AnnualIncome, @CaseNumber, @EstimatedCost, @FirstName, @ID, @LastName, @Status)...

then you refer to them in your command object parameters collection

objCommand.Parameters("@Address").Value = "....."

Peter

Dhodie · October 8th, 2003, 08:18 PM

As I am looking thru your codes i noticed a space in the variable "@Annual Income" of the CommandText property. Have it change to "@AnnualIncome"