Question

C#+Access查询值的数目与目标字段中的数目不同

OleDbCommand cmd2 = new OleDbCommand();
cn1.Open();

string sql, sql1, sql2;
sql1 = "INSERT INTO StudentInfo (StuID,StuName,Sex，Race,Address,Tel,EntranceYear,ClassID,Academy，Specialty，Role,Postal";
sql2 = " VALUES ('" + idbox.Text.ToString() + "','" + namebox.Text.ToString() + "','" + sexbox.Text.Trim() + "','" + racebox.Text.ToString() + "','" + addressbox.Text.ToString() + "','" + telbox.Text.ToString() + "','" + yearbox.Text.Trim() + "','" + banjibox.Text.Trim() + "','" + xueyuanbox.Text.Trim() + "','" + zhuanyebox.Text.Trim() + "','" + rolebox.Text.ToString() + "','" + postalbox.Text.ToString() + "'";

cmd2.Connection = cn1;
sql = sql1 + ")" + sql2 + ")";
cmd2.CommandText = sql;
cmd2.ExecuteNonQuery();
cn1.Close();
MessageBox.Show("学生信息添加成功");

我的Access数据库为

Answer 1

cmd2.CommandText = sql;
你把断点设置在这里，跟踪一下，看看sql的值对不？把值复制到sql查询分析器里面执行一下，看哪里错了就知道了。