dr = cmd.ExecuteReader(); ['='附近的语法不正确。] [英] dr = cmd.ExecuteReader(); [Incorrect syntax near '='.]
本文介绍了dr = cmd.ExecuteReader(); ['='附近的语法不正确。]的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
SqlConnection con = new SqlConnection(@"Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\Database.mdf;Integrated Security=True;User Instance=True");
String str;
str = "select * from addproduct where id = " + Session["id"] + "";
SqlCommand cmd = new SqlCommand(str, con);
SqlDataReader dr;
con.Open();
dr = cmd.ExecuteReader();
while (dr.Read())
{
Image1.ImageUrl = @"/Images/" + Image1;
lblName.Text = dr["name"].ToString();
lblPrice.Text = dr["price"].ToString();
SortDesc.Text = dr["des"].ToString();
lblLongDesc.Text = dr["Data"].ToString();
}
推荐答案
尝试:
Try:
str = "select * from addproduct where id = '" + Session["id"] + "'";
你应该添加撇号。
You should add apostrophes.
这篇关于dr = cmd.ExecuteReader(); ['='附近的语法不正确。]的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文