如何在查询中使用会话值 [英] how to use the session values in query

问题描述

int Id=Convert.ToInt32(Session["Userid"].ToString());

DataSet adminTable = new DataSet();
MySqlDataAdapter sAdapter;
sAdapter = new MySqlDataAdapter("select ordermast.orderid, orderdate, paymentno, podate from ordermast inner join paymentdetail on paymentdetail.orderid = ordermast.orderid where ordermast.adminuserid = '1'", myPConn);

我想使用id而不是1.我该怎么做

i want to use the id instead of the 1 . How can i do that

推荐答案

Concat作为字符串.

Concat as a string.

int Id=Convert.ToInt32(Session["Userid"].ToString());
 
DataSet adminTable = new DataSet();
MySqlDataAdapter sAdapter;
sAdapter = new MySqlDataAdapter("select ordermast.orderid, orderdate, paymentno, podate from ordermast inner join paymentdetail on paymentdetail.orderid = ordermast.orderid where ordermast.adminuserid = '" + Id.ToString() + "'", myPConn);

尝试一下.

Try this.

sAdapter = new MySqlDataAdapter("select ordermast.orderid, orderdate, paymentno, podate from ordermast inner join paymentdetail on paymentdetail.orderid = ordermast.orderid where ordermast.adminuserid = " + Id.ToString() + "", myPConn);

sAdapter = new MySqlDataAdapter("select ordermast.orderid, orderdate, paymentno, podate from ordermast inner join paymentdetail on paymentdetail.orderid = ordermast.orderid where ordermast.adminuserid = ''" + Session["Userid"].ToString() + "''", myPConn);

这篇关于如何在查询中使用会话值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！