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

学习 时间:2026-10-11 16:56:44 阅读:5465
string strsql1 ="select * from product where name=session[product_id]我值想返回name和amount这2个数据,该怎么写?

最佳回答

谦让的篮球

怡然的荔枝

2026-10-11 16:56:44

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-10-11 16:56:44

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

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

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