Question

insert语句错误

protected void Button1_Click(object sender, EventArgs e)
{
string username = this.TextBox1.Text;
int age = Convert.ToInt32(this.TextBox2.Text);
string sex = this.RadioButtonList1.Text;
string nation = this.TextBox3.Text;
string idf = this.TextBox4.Text;
string test_num = this.TextBox5.Text;
int m_test;
int.TryParse(this.TextBox6.Text,out m_test);
string types = this.DropDownList1.Text;
string tel = this.TextBox7.Text;
string qq = this.TextBox8.Text;
string addr = this.TextBox9.Text;
string f_school = this.TextBox10.Text;
string pos_num = this.TextBox11.Text;
string position = this.TextBox12.Text;
string profess = this.DropDownList2.Text;
string dic = this.TextBox13.Text;
string sql = string.Format("insert into student_stand(username,sex,age,nation,idf,test_num,m_test,types,tel,qq,addr,f_school,pos_num,position,profess,dic) values('{0}','{1}',{2},'{3}','{4}','{5}',{6},'{7}','{8}','{9}','{10}','{11}','{12}','{13}','{14}','{15}')", username, sex, age, nation, idf, test_num, m_test, types, tel, qq, addr, f_school, pos_num, position, profess, dic);
try
{
OleDbConnection conn = new OleDbConnection("provider=microsoft.jet.oledb.4.0;Persist Security Info=True;data source=" + Server.MapPath("database2010/&#zyschool&#.mdb"));
conn.Open();
OleDbCommand cmd = new OleDbCommand(sql, conn);
if (cmd.ExecuteNonQuery() < 1)
{
Response.Write("<script language=javascript>");
Response.Write("alert('添加失败！');");
Response.Write("</script>");
Response.Write("<script language=javascript>javascript:history.go(-1)</script>");
}
else
{
Response.Write("<script language=javascript>");
Response.Write("alert('添加成功！');");
Response.Write("</script>");
Response.Write("<script language=javascript>javascript:location.href('school_stand.aspx')</script>");
}
}
catch(Exception ex)
{
Response.Write(sql);
//Response.End();
throw new Exception(ex.ToString());
}
报的错误是insert语句语法错误，错在哪了哦？？

Answer 1

hb412569475 的疑问是正确的。

其实，最直接简单的方法就是将你要执行的SQL语句打印出来，然后就可以看看问题出在什么地方了，然后调整sql语句处理串，就可以解决问题了。

Answer 2

values('{0}',' values('0',
去掉所有花括号

Answer 3

{6}没有引号，你确定 m_test 不是字符串？