===这里为什么会错？？？

[Tomgus]

我在datagrid中有一按钮，显示数据信息：
string sbID="";
sbID=this.DataGrid1.Items[e.Item.ItemIndex].Cells[1].Text;
string contex="Server=tomgus-master;UID=sa;PWD=1111;Initial Catalog=yqsb";
string search="SELECT * FROM s_zj"+"WHERE "+"仪器编号="+sbID;

SqlConnection conn=new SqlConnection(contex);
SqlCommand cmd=new SqlCommand(search,conn);
conn.Open();
SqlDataReader dr=cmd.ExecuteReader();
dr.Read();
this.Label1.Text= BuildMoreInfoText(dr);

但是SqlDataReader dr=cmd.ExecuteReader();这句老报错！
怎样改？？？

[2002pine]

string search="SELECT * FROM s_zj"+"WHERE "+"仪器编号="+sbID;

---》
string search="SELECT * FROM s_zj"+" WHERE "+"仪器编号="+sbID;

[blackcatiii]

输出search的内容你就会发现在表名和where之间少了个空格

[timmy3310]

string search="SELECT * FROM s_zj"+" WHERE "+"仪器编号="+sbID;

Where前面少个空格

[gangganghao]

search="SELECT * FROM s_zj"+"WHERE "+"仪器编号="+sbID;
改为
search="SELECT * FROM s_zj WHERE 仪器编号="+sbID;

[timmy3310]

唉

都是高手啊

快

[unfor]

search="SELECT * FROM s_zj"+"WHERE "+"仪器编号="+sbID;
改为
search="SELECT * FROM s_zj WHERE 仪器编号="+sbID;