读书人

帮忙看看SQL的小疑点

发布时间: 2012-02-15 12:09:43 作者: rapoo

帮忙看看SQL的小问题
string city = this.txtCity.Text.ToString();

"insert into Infodepartment(城市名称) values(此处我想用city的值,我该怎么写?)) "
谢谢!

[解决办法]
string strSQL = "insert into Infodepartment(城市名称) values( ' + city + " ' ";
[解决办法]
insert into Infodepartment(城市名称) values( ' "+city+ " ')) "
[解决办法]
那就把括号加上

string strSQL = "insert into Infodepartment(城市名称) values( ' + city + " ') ";

[解决办法]
insert into Infodepartment(城市名称) values( ' "+city+ " ')
[解决办法]
string strSQL = "insert into Infodepartment(城市名称) values( ' " + city + " ') ";

to
amandag(高歌)

你的少了一个分号,一个括号...
[解决办法]
string strSQL = "insert into Infodepartment(城市名称) values( ' + city + " ') ";
少个双引号

读书人网 >C#

热点推荐