Loading

System.Data.SqlClient.SqlException:Incorrect syntax near '='

abhilash bc

my code is

SqlConnection con = new SqlConnection(clsutilities.STRCONN);

con.Open();

string query = "SELECT Rating FROM UserRating3 where pid=" + @pid;

SqlCommand cmd = new SqlCommand(query, con);

//SqlCommand cmd = new SqlCommand("SELECT Rating FROM UserRating1 ",con);

SqlDataAdapter da = new SqlDataAdapter(cmd);

DataTable dt = new DataTable();

da.Fill(dt);

if (dt.Rows.Count > 0)

{

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Ranjit Powar11y ago
Accepted answer
In your query you use parameter @pid but you don't pass any value to this parameter. Set the value for parameter.
+2
abhilash bc11y ago
thanks
0
Ravi Patel11y ago
Hi

you forgot to provide the value of pid

try this

SqlConnection con = new SqlConnection(clsutilities.STRCONN);
con.Open();
string query = "SELECT Rating FROM UserRating3 where pid=" + @pid;
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add("@pid", pid.Text);//cmd.Parameters.Add("@pid", pass the value of pid )
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
if (dt.Rows.Count > 0)
{

+1