日期:2014-05-18  浏览次数:20377 次

朋友们帮我看看SQL语句:错误 运算符“+”无法应用于“string”和“string*”类型的操作数
leDbCommand cmdInsertUser = new OleDbCommand("INSERT INTO Dv_User(UserName,UserPassword,UserEmail,UserFace,UserWidth,UserHeight,UserIM,UserClass,userWealth,userEP,userCP,UserQuesion,UserAnswer,UserFav,UserInfo,UserSetting,UserGroupID,TitlePic,UserMsg,TruePassWord,UserToday) VALUES('txtUserName.Text ','+ MD5(txtPassword.Text) + ','txtUserName.Text ','@domain.com','Images/userface/image1.gif',32,32,'||||||||||||||||||','新手上路',100,60,30,'a','b','陌生人,我的好友,黑名单','||||||||||||||||||||||||||||||||||||||||||','1|||0|||0',9,'level0.gif','0||0||null','5738509MLGn36NdG','0|0|0|0|0')",accessConn);

请帮我解决一下.

------解决方案--------------------
你就不能把字符串拼好后 再插入吗?
------解决方案--------------------
试试这个
leDbCommand cmdInsertUser = new OleDbCommand("INSERT INTO Dv_User(UserName,UserPassword,UserEmail,UserFace,UserWidth,UserHeight,UserIM,UserClass,userWealth,userEP,userCP,UserQuesion,UserAnswer,UserFav,UserInfo,UserSetting,UserGroupID,TitlePic,UserMsg,TruePassWord,UserToday) VALUES( '" + txtUserName.Text +"', '" + MD5(txtPassword.Text) + "', '" + txtUserName.Text + "', '@domain.com ','Images/userface/image1.gif ',32,32, ' ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ', '新手上路 ',100,60,30, 'a ', 'b ', '陌生人,我的好友,黑名单 ', ' ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ', '1 ¦ ¦ ¦0 ¦ ¦ ¦0 ',9, 'level0.gif ', '0 ¦ ¦0 ¦ ¦null ', '5738509MLGn36NdG ', '0 ¦0 ¦0 ¦0 ¦0 ')",accessConn); 


------解决方案--------------------
+ MD5(txtPassword.Text) + 改成 "+ MD5(txtPassword.Text) + " 其他类似
------解决方案--------------------
leDbCommand cmdInsertUser = new OleDbCommand("INSERT INTO Dv_User(UserName,UserPassword,UserEmail,UserFace,UserWidth,UserHeight,UserIM,UserClass,userWealth,userEP,userCP,UserQuesion,UserAnswer,UserFav,UserInfo,UserSetting,UserGroupID,TitlePic,UserMsg,TruePassWord,UserToday) VALUES( 'txtUserName.Text ', '+ MD5(txtPassword.Text) + ', 'txtUserName.Text ', '@domain.com ', 'Images/userface/image1.gif ',32,32, ' ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ', '新手上路 ',100,60,30, 'a ', 'b ', '陌生人,我的好友,黑名单 ', ' ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ', '1 ¦ ¦ ¦0 ¦ ¦ ¦0 ',9, 'level0.gif ', '0 ¦ ¦0 ¦ ¦null ', '5738509MLGn36NdG ', '0 ¦0 ¦0 ¦0 ¦0 ')",accessConn); 

=============>改:

leDbCommand cmdInsertUser = new OleDbCommand("INSERT INTO Dv_User(UserName,UserPassword,UserEmail,UserFace,UserWidth,UserHeight,UserIM,UserClass,userWealth,userEP,userCP,UserQuesion,UserAnswer,UserFav,UserInfo,UserSetting,UserGroupID,TitlePic,UserMsg,TruePassWord,UserToday) VALUES( 'txtUserName.Text ', '"+ MD5(txtPassword.Text) + "', 'txtUserName.Text ', '@domain.com ', 'Images/userface/image1.gif ',32,32, ' ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ¦ ', '新手上路 ',100,60,30, 'a ', 'b ', '陌生人,我的好友,黑名单 ', ' ¦ ¦ ¦ ¦ ¦ ¦ ¦ &