简单SQL语句,哪儿错了??????
khler 2007-05-21 01:00:10 OleDbConnection cn = IConnection.Open();
string sql = "insert into tbUser(Name,NickName,Password,Sex) values(";
sql += "'"+ user.Name + "','" + user.NickName + "','" + user.Password + "'," + user.Sex + ");";
OleDbCommand cmd = new OleDbCommand(sql, cn);
cmd.ExecuteNonQuery();
IConnection.Close();
执行cmd.ExecuteNonQuery();时出现异常:
2007-05-21 12:56:26,953 [14] FATAL MyLogs [(null)] <(null)> - INSERT INTO 语句的语法错误。
看了半天也没发现哪儿写错了