Question

Access 数据库 Insert into 语句的语法错误

OleDbConnection coon = new OleDbConnection(Form2.odbcConnStr);
coon.Open();
string sql = "select * from tbuser where name='"+textBox1.Text+"'";
OleDbCommand cmd = new OleDbCommand(sql,coon);
OleDbDataReader dr = cmd.ExecuteReader();
if (dr.Read())
{

MessageBox.Show("已存在该用户！", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
else
{
dr.Close();
string a = textBox1.Text;
string b = textBox2.Text;
string c = textBox3.Text;
string d = textBox4.Text;
sql = "insert into tbuser(name,password,sex,email) values('" + a + "','" + b + "','" + c + "','" + d + "')";
cmd.CommandText = sql;
cmd.ExecuteNonQuery();
MessageBox.Show("注册成功", "温馨提示", MessageBoxButtons.OK, MessageBoxIcon.Information);

}

Answer 1

今天使用ACCESS数据库中出现了错误，经过很长时间才解决问题。插入的代码相当简单。查了一些资料后才发现原来是我的ACCESS数据表的字段名使用了SQL的保留关键字。原来语句是：string str = "insert into admain( name,password) values ('" + TextBox1.Text + "','" + TextBox2.Text + "')";将插入数据的SQL语句更改为string str = "insert into admain( [name],[password]) values ('" + TextBox1.Text + "','" + TextBox2.Text + "')";即解决"INSERT INTO 语句的语法错误"的问题.将保留关键字加上中括号([]).在学习中收获分享给大家，以便共同学习。