读书人

sql语句有关问题

发布时间: 2012-04-03 12:38:19 作者: rapoo

sql语句问题?
txt_state_rk和 txt_style_rk 是 txtbox

string ztai = txt_state_rk.Text;
string xinghao = txt_style_rk.Text;

string sql = "select * from cangkulingjian where ztailj = ztai and nolj = xinghao ";

这样能找到相关数据吗
但是提示有异常
System.Data.OleDb.OleDbException: 至少一个参数没有被指定值。

[解决办法]
字段名或者表名写错了。
[解决办法]
string sql = "select * from cangkulingjian where ztailj = ' "
+ ztai + " ' and nolj = ' " + xinghao + " ' ";
[解决办法]
string sql = "select * from cangkulingjian where ztailj = ztai and nolj = xinghao ";改为
string sql = "select * from cangkulingjian where ztailj = ' "+ ztai+ " ' and nolj = ' "+ xinghao+ " ' ";

读书人网 >asp.net

热点推荐