datawindow.net 中 s_bh = "E99010";赋值问题

[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''

[永生天地]

s_where = "spxx.bh = '" + s_bh + "'";//错误在这句
s_modstring = 'DataWindow.Table.Select = "'+ s_modstring + ' where '+ s_where +'"';
dw_1.Modify(s_modstring);

这样写试试

[pb8]

应该是组织字符串的问题，你试试把代码改成这样的～～
s_modstring = 'DataWindow.Table.Select = ~"'+ s_modstring + ' where '+ s_where +'~"';
dw_1.Modify(s_modstring);