Question

sql server拼接字符串的问题.（c#）

  高手帮忙看下哪里出问题了,,             string cls = "城市";        string strsql="select * from jpsx_ddl where class="+cls;        da.SelectCommand = new SqlCommand(strsql, conn);        ds = new DataSet();        try        {            conn.Open();            da.Fill(ds, "jpsx_ddl");            conn.Close();        }        catch (SqlException e1)        {            Response.Write(e1.ToString());        }

Answer 1

字符串要打引号的，数值型才不用打，最直接的方法是把你这些字符串换成具体的内容自己拼接一下检查，向你上面的string strsql="select * from jpsx_ddl where class= 城市"; 而城市是个字符串，所以要加单引号string strsql="select * from jpsx_ddl where class=' " + cls + " ' ";

Answer 2

string cls = "城市";
string strsql="select * from jpsx_ddl where [class]='" + cls + "'";

Answer 3

你这句sql语句输出来是“select * from jpsx_ddl where class=城市”，在sqlserver中字符串要加单引号。改成string strsql="select * from jpsx_ddl where [class]='" + cls + "'";

Answer 4

cla="'城市'",要加两个单引号