string xing = txtxing.Text;
string ming = txtming.Text;
string xing1 = txtxing1.Text;
string ming1 = txtming1.Text;
string name = txtname.Text;
string name1 = txtname1.Text;
string xiedai = txtxiedai.Text;
string xiedai1 = txtxiedai1.Text;
string xingbie = RadioButton1.Checked ? "男" : "女";
string nian = txtnian.Text;
string yue = txtyue.Text;
string ri = txtri.Text;
string youbian1 = txtyoubian1.Text;
string youbian2 = txtyoubian2.Text;
string daofu = txtdaofu.Text;
string shiqu = txtshiqu.Text;
string zhusuo = txtzhusuo.Text;
string m = txtm.Text;
string dianhua = txttel.Text;
string shouji = txtmobile.Text;
string dongji = txtdongji.Text;
string yanxing = txtyanxing.Text;
string yanming = txtyanming.Text;
string yanxing1 = txtyanxing1.Text;
string yanming1 = txtyanming1.Text;
string last = txtlast.Text;
string first = txtfirst.Text;
string year = txtyear.Text;
string month = txtmonth.Text;
string date = txtdate.Text;
string xingbie2 = RadioButton3.Checked ? "男" : "女"; string insert = "insert into infoss (xings,mings,xing1,ming1,names,name1,xiedai,xiedai1,xingbie,nians,yues,ris,youbian1,youbian2,daofu,shiqu,zhusuo,mms,dianhua,shouji,dongji,yanxing,yanming,yanxing1,yanming1,lastn,firstn,xingbie2,yearss,monthss,datess) values ('" + xing + "','" + ming + "','" + xing1 + "','" + ming1 + "','" + name + "','" + name1 + "','" + xiedai + "','" + xiedai1 + "','" + xingbie + "','" + nian + "','" + yue + "','" + ri + "','" + youbian1 + "','" + youbian2 + "','" + daofu + "','" + shiqu + "','" + zhusuo + "','" + m + "','" + dianhua + "','" + shouji + "','" + dongji + "','" + yanxing + "','" + yanming + "','" + yanxing1 + "','" + yanming1 + "','" + last + "','" + first + "','" + xingbie2 + "','" + year + "','" + month + "','" + date + "')";
Run.RunSqlacc(insert);
Response.Redirect("queren.aspx");
有没有人帮忙看一下 列名不可能有错误 我对过好几遍 就是插入不了数据 总是提示语句语法有错误 ,可能是我眼花 ,我实在没看出那里有错误 求解
string ming = txtming.Text;
string xing1 = txtxing1.Text;
string ming1 = txtming1.Text;
string name = txtname.Text;
string name1 = txtname1.Text;
string xiedai = txtxiedai.Text;
string xiedai1 = txtxiedai1.Text;
string xingbie = RadioButton1.Checked ? "男" : "女";
string nian = txtnian.Text;
string yue = txtyue.Text;
string ri = txtri.Text;
string youbian1 = txtyoubian1.Text;
string youbian2 = txtyoubian2.Text;
string daofu = txtdaofu.Text;
string shiqu = txtshiqu.Text;
string zhusuo = txtzhusuo.Text;
string m = txtm.Text;
string dianhua = txttel.Text;
string shouji = txtmobile.Text;
string dongji = txtdongji.Text;
string yanxing = txtyanxing.Text;
string yanming = txtyanming.Text;
string yanxing1 = txtyanxing1.Text;
string yanming1 = txtyanming1.Text;
string last = txtlast.Text;
string first = txtfirst.Text;
string year = txtyear.Text;
string month = txtmonth.Text;
string date = txtdate.Text;
string xingbie2 = RadioButton3.Checked ? "男" : "女"; string insert = "insert into infoss (xings,mings,xing1,ming1,names,name1,xiedai,xiedai1,xingbie,nians,yues,ris,youbian1,youbian2,daofu,shiqu,zhusuo,mms,dianhua,shouji,dongji,yanxing,yanming,yanxing1,yanming1,lastn,firstn,xingbie2,yearss,monthss,datess) values ('" + xing + "','" + ming + "','" + xing1 + "','" + ming1 + "','" + name + "','" + name1 + "','" + xiedai + "','" + xiedai1 + "','" + xingbie + "','" + nian + "','" + yue + "','" + ri + "','" + youbian1 + "','" + youbian2 + "','" + daofu + "','" + shiqu + "','" + zhusuo + "','" + m + "','" + dianhua + "','" + shouji + "','" + dongji + "','" + yanxing + "','" + yanming + "','" + yanxing1 + "','" + yanming1 + "','" + last + "','" + first + "','" + xingbie2 + "','" + year + "','" + month + "','" + date + "')";
Run.RunSqlacc(insert);
Response.Redirect("queren.aspx");
有没有人帮忙看一下 列名不可能有错误 我对过好几遍 就是插入不了数据 总是提示语句语法有错误 ,可能是我眼花 ,我实在没看出那里有错误 求解
解决方案 »
- asp.net 用户控件互相调用的问题
- 没分了,不好意思哈,帮忙.为什么js调用控件的ID变了名字
- 新年的第一个贴子,来者有分,VS2005的一个困惑,怎样把.sln生成在项目文件夹里(即工程源代码同一个文件夹里)
- dropdownlist下拉如何控制长度或者默认下拉个数?
- |zyciis| 200分求 打算研究一下开源的图表控件ZedGraph控件 请大家如果有这方面的示例麻烦发个地址
- ASP.NET中怎么弹出保存文件对话框?
- 网站静态化如何实现?
- .net如何创建一个多主机头的站点!
- 如何在html里给imagebutton写点击事件
- 关于数据库连接的错误请赐教!
- 在GridView中如何写类似的提示功能?
- ASP.NET下数据库的备份和还原.....
SqlParameter 你自己去查用法了 呵呵 这个是最基本的了 开始楼上说的非常清楚了 你可以先把你的sql单步跟踪并输出sql语句 往数据库插入试一下 这个时候数据库报的是最直接的也是最容易看明白的错误
a,b,c,d,e,f 为所要插入的字段,