类似的问题又来了,为什么说我的UPDATE语法错误 oledb连接access数据库,用update语句更新记录,报语法错误。但把语句直接在access里运行可以通过,为啥哪里的问题? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 string strUptCom = "UPDATE CusBaseInfo SET IDDate='" + cisUpdate.IDDate + "',Name='" + cisUpdate.Name + "'," + "BirthDay='" + cisUpdate.BirthDay + "'" + ",Sex='" + cisUpdate.Sex + "',IfWedded='" + cisUpdate.IfWedded + "'," + "IfSy='" + cisUpdate.IfSy + "',Stature='" + cisUpdate.Stature + "'" + ",Avoirdupois='" + cisUpdate.Avoirdupois + "',Telephone='" + cisUpdate.Telephone + "',Handset='" + cisUpdate.Handset + "'," + "Address='" + cisUpdate.Address + "',Eating='" + cisUpdate.Eating + "',Splanchnic='" + cisUpdate.Splanchnic + "'," + "Sleeping='" + cisUpdate.Sleeping + "',Slzq='" + cisUpdate.Slzq + "',Character='" + cisUpdate.Character + "'," + "Sporting='" + cisUpdate.Sporting + "',Drinking='" + cisUpdate.Drinking + "',BonesAndMuscle='" + cisUpdate.BonesAndMuscle + "'," + "IllHis='" + cisUpdate.IllHis + "',Tongue='" + cisUpdate.Tongue + "',Shape='" + cisUpdate.Shape + "'," + "Other='" + cisUpdate.Other + "',Skin1='" + cisUpdate.Skin1 + "',Skin2='" + cisUpdate.Skin2 + "'," + "Skin3='" + cisUpdate.Skin3 + "',Skin4='" + cisUpdate.Skin4 + "',Living='" + cisUpdate.Living + "'," + "PerOfTre='" + cisUpdate.PerOfTre + "',Requirement='" + cisUpdate.Requirement + "' WHERE ID='" + cisUpdate.ID + "' AND Type='" + cisUpdate.Type + "'"; 语句在access下直接运行没问题的 语句在access下直接运行没问题的------你确信程序中构造的sql语句和access中测试的语句相同? 在access中运行的语句是调试的时候直接拷下来的数据库的使用权限也没问题,因为insert是可以的 我以前也遇到过这种问题,可能还是access数据库的原因,我最后选择放弃,改用sql 请问这个问题是否不能用反射来解决? 简单问题,需要实例,TextBox 如何限制数据字数 5-10 位 实现只能运行一个实例,当第二次双击程序运行时把第一个激活并传递参数进去 愁云上心头,谁能解我忧——C#调用dll的问题 請問vs2005的C#中int? min=null; 這一句是什麼意思 ,int後還跟一個問號。 如何在C#的web页面上实现文件、文件夹的创建、删除,是否需进行相应的设置? 在C#中怎样动态加载COM? 一个比较奇怪的构造器 请问:C#中 虚基类 等于 抽象类吗? 意见征集中...... html控件与web窗体控件的区别? 大家看看下面这段代码有什么错误?
"BirthDay='" + cisUpdate.BirthDay + "'" + ",Sex='" + cisUpdate.Sex + "',IfWedded='" + cisUpdate.IfWedded + "'," +
"IfSy='" + cisUpdate.IfSy + "',Stature='" + cisUpdate.Stature + "'" + ",Avoirdupois='" + cisUpdate.Avoirdupois +
"',Telephone='" + cisUpdate.Telephone + "',Handset='" + cisUpdate.Handset + "'," + "Address='" + cisUpdate.Address +
"',Eating='" + cisUpdate.Eating + "',Splanchnic='" + cisUpdate.Splanchnic + "'," + "Sleeping='" + cisUpdate.Sleeping +
"',Slzq='" + cisUpdate.Slzq + "',Character='" + cisUpdate.Character + "'," + "Sporting='" + cisUpdate.Sporting +
"',Drinking='" + cisUpdate.Drinking + "',BonesAndMuscle='" + cisUpdate.BonesAndMuscle + "'," + "IllHis='" + cisUpdate.IllHis +
"',Tongue='" + cisUpdate.Tongue + "',Shape='" + cisUpdate.Shape + "'," + "Other='" + cisUpdate.Other +
"',Skin1='" + cisUpdate.Skin1 + "',Skin2='" + cisUpdate.Skin2 + "'," + "Skin3='" + cisUpdate.Skin3 +
"',Skin4='" + cisUpdate.Skin4 + "',Living='" + cisUpdate.Living + "'," + "PerOfTre='" + cisUpdate.PerOfTre +
"',Requirement='" + cisUpdate.Requirement + "' WHERE ID='" + cisUpdate.ID + "' AND Type='" + cisUpdate.Type + "'";
数据库的使用权限也没问题,因为insert是可以的