带参数sql语句怎么不能在程序中把参数带进去?
OleDbCommand qbComm=conn.CreateCommand();
qbComm.CommandText = "select jbcc from qb_sjr_bt where to_char(rksj,'yyyymmdd') = '@rksj'";
qbComm.Parameters.Add("@rksj",OleDbType.Char,8);
qbComm.Parameters["@rksj"].Value = "@rksj";
OleDbDataReader qbReader = qbComm.ExecuteReader();
while(qbReader.Read())
{
listBox1.Items.Add(qbReader["jbcc"]);
}
程序片断如上,后台用的是oracle9i,如果把sql语句的参数换成固定的数值,则可以返回结果,但如果把@rksj用别的方法取得,则不能返回任何结果,也不报错!
请哪位大虾指点一下!