本文介绍了使用动态创建的SQL Insert语句时出错的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我可以知道我的陈述有什么问题吗?我收到语法错误。试图找出有什么问题,整天。 :(
cmd.CommandText =INSERT INTO LogIn(Username,Password)VALUES('+ AddUsernameTextBox.Text + ,''+ AddPasswordTextBox.Text +');解决方案
pre> cmd.CommandText =INSERT INTO LogIn([Username],[Password])VALUES('+ AddUsernameTextBox.Text +','+ AddPasswordTextBox.Text +') ;
此代码将有助于如果错误是由于保留关键字: - 用户名和密码。如果不是这样,则引用错误。
May I know what's wrong with my statement? I receive a syntax error. Been trying to find out what's wrong all day. :(
cmd.CommandText = "INSERT INTO LogIn(Username,Password) VALUES('" + AddUsernameTextBox.Text + "','" + AddPasswordTextBox.Text + "')";解决方案 cmd.CommandText = "INSERT INTO LogIn([Username],[Password]) VALUES('" + AddUsernameTextBox.Text + "','" + AddPasswordTextBox.Text + "')";
This code will help if the error is due to reserved keywords :- username and password. Please quote the error if this is not the case .
更多推荐
使用动态创建的SQL Insert语句时出错
发布评论