这段SQL语句中,实际a=500,是有数据的,但是结果运行到da1的时候错误了,如果用select * from wenshu 就不会错,带where id=变量的时候错了。那么sql语句到底错在哪里? string a = Request["id"];
if (a != null )
{
string strConn1 = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|tax.mdb;Persist Security Info=True";
OleDbConnection myConnection1 = new OleDbConnection();
myConnection1.ConnectionString = strConn1;
string strCommand1 = "SELECT * FROM [wenshu] where id= '"+a+"'";
OleDbDataAdapter da1 = new OleDbDataAdapter(strCommand1, myConnection1);
DataSet ds1 = new DataSet();
da1.Fill(ds1, "wenshu"); DataList1.DataSource = ds1.Tables["wenshu"].DefaultView;
DataList1.DataBind();
if (a != null )
{
string strConn1 = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|tax.mdb;Persist Security Info=True";
OleDbConnection myConnection1 = new OleDbConnection();
myConnection1.ConnectionString = strConn1;
string strCommand1 = "SELECT * FROM [wenshu] where id= '"+a+"'";
OleDbDataAdapter da1 = new OleDbDataAdapter(strCommand1, myConnection1);
DataSet ds1 = new DataSet();
da1.Fill(ds1, "wenshu"); DataList1.DataSource = ds1.Tables["wenshu"].DefaultView;
DataList1.DataBind();
解决方案 »
- SerialPort 串口打开异常,第一次打开正常,关闭窗体后,再打开就异常!!
- (散分)输出为什么和计算器算出来的不一样?
- Socket发送时可以使用固定的端口么???比如8000端口发送
- ★★★怎样用DataSet通过行号取得DataGridView中选中的行?
- 请问从另一个服务器上追加记录时怎么判断已经追加过的记录?
- 请教高手
- 写一个简单的AD域筛选器 searcher.Filte,大神速进!!在线等!
- 如何编写自定义的控件???
- 求助!
- vb.net里面的mustoverride在c#里面的语法是什么?谢谢
- 海康威视视频卡录像问题 C++与C#高手来 急
- C#中如何去读取Excel表格?
string strCommand1 = "SELECT * FROM [wenshu] where id= "+a;
string a = Request["id"];
if (a != null )
{
string strConn1 = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|tax.mdb;Persist Security Info=True";
OleDbConnection myConnection1 = new OleDbConnection();
myConnection1.ConnectionString = strConn1;
string strCommand1 = "SELECT * FROM [wenshu] where [id]= "+int.Parse(a);
OleDbDataAdapter da1 = new OleDbDataAdapter(strCommand1, myConnection1);
DataSet ds1 = new DataSet();
da1.Fill(ds1, "wenshu"); DataList1.DataSource = ds1.Tables["wenshu"].DefaultView;
DataList1.DataBind();
2、string strCommand1 = "SELECT * FROM [wenshu] where id= "+a;
3、string strCommand1 = "SELECT * FROM [wenshu] where [id]= '"+a+"'";
4、string strCommand1 = "SELECT * FROM [wenshu] where [id]= "+a+"";
5、string strCommand1 = "SELECT * FROM [wenshu] where id= "+a+"";