Fix error "incorrect syntax near =...sqldatareader sdr = cmd.executereader(); "

See more:

C#

public UserAcct(string name, string password)
{
string conString = WebConfigurationManager.ConnectionStrings
["StoreConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(conString);
SqlCommand cmd = new SqlCommand("Select User ID, Role, Email from [Users] where name = @name and PWDCOMPARE(@password, password = 1", con);
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@name", name);
cmd.Parameters.AddWithValue("@password", password);
con.Open();

SqlDataReader sdr = cmd.ExecuteReader();
if (sdr.HasRows)
{
sdr.Read();
this.UserId = (int)sdr[0];
this.Name = name;
this.Role = (string)sdr[1];
this.Email = (string)sdr[2];

//Session["User"] = this;
//if (this.Role == "user")
// Session["Cart"] = new ShoppingCart();
}
else
{
this.UserId = 0;
}
con.Close();
}

What I have tried:

I haven't tried anything other than googling the problem, I don't know where to start.