dr = cmd.ExecuteReader（）; ['='附近的语法不正确。] [英] dr = cmd.ExecuteReader(); [Incorrect syntax near '='.]

问题描述

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屋！