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

Question

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)

{

Ranjit Powar · Answer

In your query you use parameter @pid but you don't pass any value to this parameter. Set the value for parameter.

abhilash bc · Answer

thanks

Ravi Patel · Answer

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) {