datawindow.net 赋值问题

[zixuanzitong]

protected void Button1_Click(object sender, EventArgs e)
{
dw_1.SetTransaction(Trans);

string s_modstring;
string s_where;
string s_bh;
s_bh = TextBox2.Text;
s_bh = "E99010"; ？
s_modstring=dw_1.Describe("DataWindow.Table.Select");
s_where = "spxx.bh = '" + s_bh + "'";//错误在这句
//s_modstring = "DataWindow.Table.Select = '"+ s_modstring + "where "+ s_where +"'";
dw_1.Modify(s_modstring);
Response.Write(s_modstring);
dw_1.Retrieve();
//Response.Write(" <script language=javascript>alert('" + s_modstring + "') </script>");

}
正缺的
sql语句中

DataWindow.Table.Select = ' SELECT spxx.bh , spxx.bz , spxx.cm , spxx.gxsj , spxx.kcbj , spxx.pp , spxx.ys , spxx.编号 FROM spxx where spxx.bh=~"E99010~"

得到的错误的sql 是
DataWindow.Table.Select = ' SELECT spxx.bh , spxx.bz , spxx.cm , spxx.gxsj , spxx.kcbj , spxx.pp , spxx.ys , spxx.编号 FROM spxx where spxx.bh = 'E99010''





对我有用[0] 丢个板砖[0] 引用 举报 管理 TOP 回复次数：0

[kang_zhi_xiong13456]

s_bh = "E99010"; ？ 难道你这句话不报错吗？

[zhulong1111]

string.Format()

s_where =string.Format( "spxx.bh ={0}",s_bh );//

[zixuanzitong]

没人知道啊？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？？