How to use SqlCommand Bound Parameters

[johnaregan]

Hi
I am trying to insert into Northwind using bound paramters, the command returns the SQL Server error:
Line 1: Incorrect syntax near '?'.
Can anybody see what it is that I am doing wrong? I have seen similar code on the web.

...
comm.CommandType = CommandType.Text;
comm.CommandText = "INSERT INTO Employees (FirstName, LastName) VALUES (?, ?)";
comm.Parameters.Add("FirstName", SqlDbType.NVarChar, 20);
comm.Parameters["FirstName"].Value = "Bob";
comm.Parameters.Add("LastName", SqlDbType.NVarChar, 20);
comm.Parameters["@LastName"].Value = "Bobs";
...

 

[ca8msm]

I think for SQL server you would have to create your SQL statement parameters like:

comm.CommandText = "INSERT INTO Employees (FirstName, LastName) VALUES (@FirstName,@LastName)";

Then, add them like:

comm.Parameters.Add(new SqlParameter("@FirstName", SqlDbType.NVarChar, 11));
comm.Parameters.Add(new SqlParameter("@LastName", SqlDbType.NVarChar, 40));
cmd.Parameters["@FirstName"].Value = txtFirstName.Text;
cmd.Parameters["@LastName"].Value = txtLastName.Text;

____________________________________________________________

Need help finding an answer?

Try the Search Facility or read FAQ222-2244 on how to get better results.

 

[johnaregan]

ok thanks ca8msm