CODEWITHSUNDEEP
c#sqlsql-server
Igor Marvinsky
Igor Marvinsky

Reputation: 387

Problems with adding query parameters

Code:

com.CommandText = "select username, pass from Employees where lastName like '@Last' and firstName like '@First'";
com.Parameters.AddWithValue("@Last", lastName); // lastName is a method argument

SqlParameter param = new SqlParameter();
param.ParameterName = "@First";
param.Value = firstName;
com.Parameters.Add(param);

No matter what I do, the parameters are not inserted. What gives?

Upvotes: 0

Views: 119

Answers (2)

THEn
THEn

Reputation: 1938

try to change the '@Last' to @Last, same thing for First...

Upvotes: 2

Mike Marshall
Mike Marshall

Reputation: 7850

Do not put single quotes around your parameters, these are implied anyway.

Also, try using SqlCommand.CreateParameter as well:

com.CommandText = "select username, pass from Employees where lastName like @Last and firstName like @First";
com.Parameters.AddWithValue("@Last", lastName); // lastName is a method argument

SqlParameter param = com.CreateParameter();
param.ParameterName = "@First";
param.Value = firstName;
com.Parameters.Add(param);

Upvotes: 4

Related Questions