c#中如何传入sql参数？
我想执行的是select * from mytable where riqi between xx and yy.
其中xx和yy由用户输入，请问如何将参数传入？
我试的方法是：... riqi between @riqi
这个方法，对于传入一个值是没问题的，但传入上述类似的范围会提示语法错误。
[解决办法]
学习~
[解决办法]
String _SQL= "select * from mytable where riqi between ' "+变量A+ " ' and ' "+变量B+ " ' ";
[解决办法]
定义二个参数嘛
select * from mytable where riqi between @xx and @yy
[解决办法]
String _SQL= "select * from mytable where riqi between "+ xx.ToString() + " and "+ yy.ToString()+ " ";
[解决办法]
string strSql= "select * from mytable where riqi between @XX and @YY "
SqlCommand cmd=new SqlCommand(strSql,conn);
cmd.Parameters.Add( "@XX ",SqlDBType.DateTime);
cmd.Parameters.Add( "@YY ",SqlDBType.DateTime);
cmd.Parameters[ "@XX "].value=你要给的;
cmd.Parameters[ "@YY "].value=你要给的;
....
