我在insert数据的时候,IE提示出错信息为:Syntax error in INSERT INTO statement
我实在看不出哪里写的不对啊,哪位能帮我看看呢?谢谢!下面是代码:
string item=this.txbItemID.Text.ToString();
string goodm=this.txbGoodM.Text.ToString();
string project=this.txbPrjtN.Text.ToString();
string length=this.txbLength.Text.ToString();
string size=this.txbSize.Text.ToString();
string qty=this.txbQty.Text.ToString();
string weight=this.txbWeight.Text.ToString();
string comdate=this.txbComDate.Text.ToString();
string draw=this.txbDrawNo.Text.ToString();
string location=this.txbLocation.Text.ToString();
string pains=this.txbPainStatus.Text.ToString();
string weld=this.txbWeldStatus.Text.ToString();
string re=this.txbRemak.Text.ToString();
string own=this.txbOwn.Text.ToString();
string delivery=this.txbDelivery.Text.ToString(); string strCon =@"Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("FinishGoods.mdb");
OleDbConnection myConn = new OleDbConnection ( strCon ) ;
myConn.Open();
OleDbCommand cmd=new OleDbCommand("insert into ItemMaster(ITEMID,GOODMEM,PROJNO,LENGTH,SIZE,QTY,WEIGHT,COMPDATE,DRAWNO,LOCATION,PAINTSTATUS,WELDSTATUS,REMARK,OWNBY,DELBY) Values(@item,@goodm,@project,@length,@size,@qty,@weight,@comdate,@draw,@location,@pains,@weld,@re,@own,@delivery)",myConn);
cmd.Parameters.Add(@item,OleDbType.VarChar,50);
cmd.Parameters.Add(@goodm,OleDbType.VarChar,50);
cmd.Parameters.Add(@project,OleDbType.VarChar,50);
cmd.Parameters.Add(@length,OleDbType.VarChar,50);
cmd.Parameters.Add(@size,OleDbType.VarChar,50);
cmd.Parameters.Add(@qty,OleDbType.VarChar,50);
cmd.Parameters.Add(@weight,OleDbType.VarChar,50);
cmd.Parameters.Add(@comdate,OleDbType.VarChar,50);
cmd.Parameters.Add(@draw,OleDbType.VarChar,50);
cmd.Parameters.Add(@location,OleDbType.VarChar,50);
cmd.Parameters.Add(@pains,OleDbType.VarChar,50);
cmd.Parameters.Add(@weld,OleDbType.VarChar,50);
cmd.Parameters.Add(@re,OleDbType.VarChar,50);
cmd.Parameters.Add(@own,OleDbType.VarChar,50);
cmd.Parameters.Add(@delivery,OleDbType.VarChar,50); cmd.Parameters[0].Value=item;
cmd.Parameters[1].Value=goodm;
cmd.Parameters[2].Value=project;
cmd.Parameters[3].Value=length;
cmd.Parameters[4].Value=size;
cmd.Parameters[5].Value=qty;
cmd.Parameters[6].Value=weight;
cmd.Parameters[7].Value=comdate;
cmd.Parameters[8].Value=draw;
cmd.Parameters[9].Value=location;
cmd.Parameters[10].Value=pains;
cmd.Parameters[11].Value=weld;
cmd.Parameters[12].Value=re;
cmd.Parameters[13].Value=own;
cmd.Parameters[14].Value=delivery;
cmd.ExecuteNonQuery();
myConn.Close();
我实在看不出哪里写的不对啊,哪位能帮我看看呢?谢谢!下面是代码:
string item=this.txbItemID.Text.ToString();
string goodm=this.txbGoodM.Text.ToString();
string project=this.txbPrjtN.Text.ToString();
string length=this.txbLength.Text.ToString();
string size=this.txbSize.Text.ToString();
string qty=this.txbQty.Text.ToString();
string weight=this.txbWeight.Text.ToString();
string comdate=this.txbComDate.Text.ToString();
string draw=this.txbDrawNo.Text.ToString();
string location=this.txbLocation.Text.ToString();
string pains=this.txbPainStatus.Text.ToString();
string weld=this.txbWeldStatus.Text.ToString();
string re=this.txbRemak.Text.ToString();
string own=this.txbOwn.Text.ToString();
string delivery=this.txbDelivery.Text.ToString(); string strCon =@"Provider=Microsoft.Jet.OLEDB.4.0; Data source=" + Server.MapPath("FinishGoods.mdb");
OleDbConnection myConn = new OleDbConnection ( strCon ) ;
myConn.Open();
OleDbCommand cmd=new OleDbCommand("insert into ItemMaster(ITEMID,GOODMEM,PROJNO,LENGTH,SIZE,QTY,WEIGHT,COMPDATE,DRAWNO,LOCATION,PAINTSTATUS,WELDSTATUS,REMARK,OWNBY,DELBY) Values(@item,@goodm,@project,@length,@size,@qty,@weight,@comdate,@draw,@location,@pains,@weld,@re,@own,@delivery)",myConn);
cmd.Parameters.Add(@item,OleDbType.VarChar,50);
cmd.Parameters.Add(@goodm,OleDbType.VarChar,50);
cmd.Parameters.Add(@project,OleDbType.VarChar,50);
cmd.Parameters.Add(@length,OleDbType.VarChar,50);
cmd.Parameters.Add(@size,OleDbType.VarChar,50);
cmd.Parameters.Add(@qty,OleDbType.VarChar,50);
cmd.Parameters.Add(@weight,OleDbType.VarChar,50);
cmd.Parameters.Add(@comdate,OleDbType.VarChar,50);
cmd.Parameters.Add(@draw,OleDbType.VarChar,50);
cmd.Parameters.Add(@location,OleDbType.VarChar,50);
cmd.Parameters.Add(@pains,OleDbType.VarChar,50);
cmd.Parameters.Add(@weld,OleDbType.VarChar,50);
cmd.Parameters.Add(@re,OleDbType.VarChar,50);
cmd.Parameters.Add(@own,OleDbType.VarChar,50);
cmd.Parameters.Add(@delivery,OleDbType.VarChar,50); cmd.Parameters[0].Value=item;
cmd.Parameters[1].Value=goodm;
cmd.Parameters[2].Value=project;
cmd.Parameters[3].Value=length;
cmd.Parameters[4].Value=size;
cmd.Parameters[5].Value=qty;
cmd.Parameters[6].Value=weight;
cmd.Parameters[7].Value=comdate;
cmd.Parameters[8].Value=draw;
cmd.Parameters[9].Value=location;
cmd.Parameters[10].Value=pains;
cmd.Parameters[11].Value=weld;
cmd.Parameters[12].Value=re;
cmd.Parameters[13].Value=own;
cmd.Parameters[14].Value=delivery;
cmd.ExecuteNonQuery();
myConn.Close();
解决方案 »
- 在Asp.net页面添加一个<button onclick='window.location="aa.aspx">会自动PostBack,怎样禁止
- Win 7可以安装的Sql server 2005
- 急急急 求手写分页 无控件的 请瞪大你的眼睛看清楚
- 求教:怎样在GridView的模板列中的CheckBox点击后取得当前行的Index?
- aspx引入样式表的问题
- 这样的学习asp.net方法~在以后开发会遇到哪些麻烦?!
- 请问,,如何在框架中打开别人的网页的时候自动转到网页的某个位置显示???
- 求网页之间传递数据的问题!
- 我在做一个网站统计系统时,在统计页面的时候总是要刷新网站页面时才能获取客户端的基本信息?
- 。NET建立项目不成功是怎么回事啊?
- 如何在各个分页的页面间切换时,保存各个页面的js对象的值
- 如何在按钮单击事件中刷新本页?
加个中括号看看。[SIZE]
还不行的话,换个名字试试看。
不只是size,另外length,location,weight等等都太熟悉了,建议还是把变量加个前缀再使用吧(比如i_size)
用sql事件探查器追踪下......看看是什么错误.
然后到事件探查器中看一下...检查sql语句比较好的办法