string strsql1 ="select * from product where name=session[product_id]我值想返回name和amount这2个数据,该怎么写?

来源:学生作业帮助网 编辑:作业帮 时间:2024/04/28 17:43:18

string strsql1 ="select * from product where name=session[product_id]
我值想返回name和amount这2个数据,该怎么写?

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