C# access数据库的小问题 - .NET技术 / C#

using(OleDbConnection conn = new OleDbConnection(Properties.Settings.Default.urlRecordConnectionString))
  {
  try
  {
  string sql = "insert into view(url) values(" + this.toolStripComboBoxUrl.Text + ")";
  OleDbCommand cmd = new OleDbCommand(sql, conn);
  conn.Open();
  int n = cmd.ExecuteNonQuery();
  }
  catch (Exception err)
  {
  MessageBox.Show("view:" + err.Message);
  }
上面的代码运行时总是提示insert into 语句的语法错误~~~请高手解答一下

---

要用单引号引用变量

string sql = "insert into view (url) values('" + this.toolStripComboBoxUrl.Text + "')";

---

楼上正解。

---

这个我已经试过了,没用哇...

引用

要用单引号引用变量

string sql = "insert into view (url) values('" + this.toolStripComboBoxUrl.Text + "')";

---

楼上正解，insert into view(url) values('" + this.toolStripComboBoxUrl.Text + " ')
插入的只应该是char型的，所以得加上''

---

谢谢~问题解决了~但是不明白具体是什么原因?能说明下吗?

引用

string sql = "insert into [view]([url]) values('&quo