Question

string strsql1 ="select * from product where name=session[product_id]

我值想返回name和amount这2个数据，该怎么写？？？？

Answer 1

sql_view = "select * from tsmreturnmoneyrecord where id='" + Request.QueryString["rid"] + "'";
OleDbDataReader dr1 = list.GetList(sql_view);
if (dr1.Read())
{
txtorderid.Text = dr1["OrderId"].ToString();//订单编号
txtCustomer.Text = dr1["Customer"].ToString();//客户
txtSalesMan.Text = dr1["SalesMan"].ToString();//业务员
DropDownList1.Text = dr1["TimeCount"].ToString();//期次
txtReturnDate.Text = dr1["ReturnDate"].ToString();//回款时间
txtReturnMoney.Text = dr1["ReturnMoney"].ToString();//回款金额
DropDownList3.Text = dr1["PayType"].ToString();//付款类型
RadioButtonList1.Text = dr1["Invoice"].ToString();//是否开发票
txtReturnRemark.Text = dr1["Remark"].ToString();//备注
}
dr1.Close();

Answer 2

tring strsql1 ="select name, amount from product where name=session[product_id]"

Answer 3

string s_str,old_sql
old_sql = dw_1.getsqlselect()
s_str = old_sql + ' Where name = ' + '~'' + sle_1.text + '~''
dw_1.setsqlselect(s_str)
dw_1.settransobject(sqlca)
dw_1.retrieve()
dw_1.setsqlselect(old_sql)

注意，你的dw_1的datawindows中不要写where条件，就写到From biao1就可以了，后面的条件通过string值自动添加。如果你再初期显示的时候，你不想看到datawindows显示所有的表记录，你可以这么写datawindows的初始化SQL，Select * from biao1 where (1=0) 这样显示出来的就是空白页面，然后你把s_str = old_sql + ' Where name = ' + '~'' + sle_1.text + '~''这句，改为
s_str = old_sql + ' Or (name = ' + '~'' + sle_1.text + '~')'就可以了。