作业帮 > 综合 > 作业

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

来源:学生作业帮 编辑:作业帮 分类:综合作业 时间:2024/11/08 19:44:26
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();