[求助]请问sql中where后面的条件能不能整个用变量代替?
就是string c=" ID='2007' and class='数学'";
SqlCommand cmd=new SqlCommand("select * from aa where '"+c+"'")
我这样写出错.
[此贴子已经被作者于2007-10-13 16:50:16编辑过]
就是string c=" ID='2007' and class='数学'";
SqlCommand cmd=new SqlCommand("select * from aa where '"+c+"'")
我这样写出错.
[此贴子已经被作者于2007-10-13 16:50:16编辑过]
2007-10-13 16:49
2007-10-13 16:56
2007-10-13 17:04
string c=" ID='2007' and class='数学'";
SqlCommand cmd=new SqlCommand("select * from aa where "+c);
这样试试。
2007-10-13 18:51
2007-10-13 19:18
是的.
慢慢积累经验吧.存储过程很简单的.去SQLSERVER版块看下就知道了.
欢迎来我的网站啊:http://www.oaiyc.com
2007-10-14 01:54