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

学习 时间:2026-04-02 18:54:57 阅读:7512
string strsql1 ="select * from product where name=session[product_id]我值想返回name和amount这2个数据,该怎么写?

最佳回答

机智的猫咪

失眠的盼望

2026-04-02 18:54:57

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();

最新回答共有2条回答

  • 从容的裙子
    回复
    2026-04-02 18:54:57

    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();

上一篇 有什么动物的成长变化奇特

下一篇 时尚沙发品牌哪个款式好