放在CommandText中的查询语句问题

[xiaoniu19851005]

我想在textBox1中输入查询条件，然后点击按钮进行查询， 本来这样写的
comm.CommandText = "SELECT * FROM Student WHERE (Sname= textBox1.Text)";
可是错误的，正确的该怎么写呢，还是需要进行别的处理么

[etherealkite]

comm.CommandText = "SELECT * FROM Student WHERE Sname= '"+textBox1.Text+"'"; 

[dayizhixiaotutu]

comm.CommandText = "SELECT * FROM Student WHERE Sname=" +textBox1.Text; 

[s330481]

comm.CommandText = "SELECT * FROM Student WHERE Sname= "+textBox1.Text;

[我姓区不姓区]

[Quote=引用 1 楼 etherealkite 的回复:]
C# codecomm.CommandText="SELECT * FROM Student WHERE Sname= '"+textBox1.Text+"'";
[/Quote]

[贫僧又回来了]

[Quote=引用 1 楼 etherealkite 的回复:]
C# code
comm.CommandText = "SELECT * FROM Student WHERE Sname= '"+textBox1.Text+"'";
[/Quote]
字符型的用上面这个!

要是数字的话用下面这个
comm.CommandText = "SELECT * FROM Student WHERE Sname=" +textBox1.Text;