帮忙看看SQL的小问题

[优途科技]

string city = this.txtCity.Text.ToString();

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

[amandag]

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

[优途科技]

能写清楚些吗?我很菜的!谢谢,后面好像少了括号!

[yuan200809]

insert into Infodepartment(城市名称) values('"+city+"'))"

[zhanglizhao]

那就把括号加上

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

[yuan200809]

insert into Infodepartment(城市名称) values('"+city+"')

[xiaotupansy]

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

to
amandag(高歌)

你的少了一个分号,一个括号...

[yuan200809]

string strSQL = "insert into Infodepartment(城市名称) values(' + city + "')";
少个双引号

[优途科技]

谢谢各位!