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个数据,该怎么写?
我值想返回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();
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();
string strsql1 ="select * from product where name=session[pr
String sql = "select * from tb_consumer where account='" + a
select count(*) from v$process a,v$session b where a.addr =
$query = "SELECT * FROM student_info WHERE name = '".$login_
SELECT name FROM [BookStore].[dbo].[user] WHERE userid=?AND
string sql = "select * from user where user_name='" +t1.Text
下面的SQL语句select * from [viwBasket] where tblUser='" + (string
$id="select id from account where name='".$_SESSION['login']
PHP数据库的mysql_query("SELECT * FROM list WHERE name=这里怎么写能让nam
英语翻译select top 4 * from shop_books where anclassid = (select
select * from book where 1=1
新手提问,望大家解答帮忙看下这个string sqlstr = "select usertype from Users