"=' 附近有语法错误。

[renye0907]

string strconn = "server=WWW-51F7B2A9835\\SqlExpress;Initial Catalog=student;Integrated security=SSPI";
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlDataAdapter myad = new SqlDataAdapter("select t_no, t_name,t_post from teacher where t_no==num .Text.Tostring() | t_name==name.Text.Tostring() | t_post==zichen.Text.tostring()",conn );
DataSet ds = new DataSet();
myad.Fill(ds, "teacher");
DataGrid1.DataSource = ds;
DataGrid1.DataBind();
}

myad.Fill(ds, "teacher");这句有错

[cja03]

"select t_no, t_name,t_post from teacher where t_no==num .Text.Tostring() | t_name==name.Text.Tostring() | t_post==zichen.Text.tostring()"

"select t_no, t_name, t_post from teacher where t_no=" + num.Text + //这个t_no不知道你是不是用int型的
" or t_name = '" + name.Text +"' or t_post = '" + zichen.Text + "'"

[zzxap]

where t_no=='"+num.Text.Tostring() +"'

[wb78845838]

呵呵，字符有这么拼接的吗？

[liu4545533]

[Quote=引用楼主 renye0907 的帖子:]

string strconn = "server=WWW-51F7B2A9835\\SqlExpress;Initial Catalog=student;Integrated security=SSPI";
SqlConnection conn = new SqlConnection(strconn);
conn.Open();
SqlDataAdapter myad = new SqlDataAdapter("select t_no, t_name,t_post from teacher where t_no==num .Text.Tostring() | t_name==name.Text.Tostring() | t_post==zichen.Text.tostring()",conn );
DataSet ds = new…
[/Quote]
应该为：
"select t_no, t_name,t_post from teacher where t_no="+num .Text.Tostring() "or t_name="+name.Text.Tostring() "or t_post="zichen.Text.tostring()

[liu4545533]

"select t_no, t_name,t_post from teacher where t_no= '"+num .Text.Tostring() "'or t_name='"+name.Text.Tostring() "' or t_post='"zichen.Text.tostring()

[syb1045]

select t_no, t_name,t_post from teacher where t_no==num .Text.Tostring() | t_name==name.Text.Tostring() | t_post==zichen.Text.tostring()

有用2个‘=’号拼写的？

select t_no, t_name,t_post from teacher where t_no='"+num .Text.Tostring()+"' t_name'"+=name.Text.Tostring()+"' | t_post='"+zichen.Text.tostring()+"'

如果是int型的就去掉 ''
如
where t_no="+num.Text.Tostring() +"

[changmengmeng]

select t_no, t_name,t_post from teacher where t_no='"+num .Text.Tostring()+"' t_name='"+name.Text.Tostring()+"' | t_post='"+zichen.Text.tostring()+"'

如果t_no是int型的，就num.text.toint32()

[renye0907]

该成你们说的那个样子的话那个Tostring就不行了