sql语句有关问题

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+ " ' ";