.net运行错误问题

Question

string strUserName=Request["name"];
string strUserPassword=Request["Password1"];
string strUserPassword2=Request["Password2"];
string strUserEmail=Request["email"];
string strUserQuestion=Request["question"];
string strUserAnswer=Request["answer"];
string strUserQq=Request["qq"];
string strUserIcq=Request["icq"];
string strUserMsn=Request["msn"];


   OleDbConnection Conn=new OleDbConnection();
   Conn.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0;"+"Data Source="+Server.MapPath("person.mdb");
   Conn.Open();
 string sql1="insert into grade(Name,Password1,Password2,email,question,answer,group,qq,icq,msn)values('"+strUserName+"','"+strUserPassword+"','"+
strUserPassword2+"','"+strUserEmail+"','"+strUserQuestion+"','"+strUserAnswer+"','"+strUserQq+"','"+strUserIcq+"','"+strUserMsn+"')";
 
   OleDbCommand Comm=new OleDbCommand(sql1,Conn);
   Comm.ExecuteNonQuery();
   OleDbCommand Comm1=new OleDbCommand("select * from  grade",Conn);
   OleDbDataReader dr=Comm1.ExecuteReader();
   
   dg.DataSource=dr;
   dg.DataBind();
   Conn.Close();
   Response.Write("操作成功");
   }
</script>
<asp:DataGrid id="dg" runat="server"/>
真个运行后提示insert into grade语法错误,Comm.ExecuteNonQuery()显示红色.怎么才能解决
请大侠解决一下,最好说一下qq,谢谢了,我的qq936661878

Answer 1

group 没有插入該值!
你sql本来需要10个值 而你只传了9个

Answer 2

string sql1="insert into grade
(Name,
Password1,
Password2,
email,
question,
answer,
group,
qq,
icq,
msn)
values
('"+strUserName+"',
'"+strUserPassword+"',
'"+strUserPassword2+"',
'"+strUserEmail+"',
'"+strUserQuestion+"',
'"+strUserAnswer+"',
'"+strUserQq+"',
'"+strUserIcq+"',
'"+strUserMsn+"'
)"; 参数确实少一个 ！

Answer 3

string sql1="insert into grade(Name,Password1,Password2,email,question,answer,group,qq,icq,msn)values('"+strUserName+"','"+strUserPassword+"','"+ 
strUserPassword2+"','"+strUserEmail+"','"+strUserQuestion+"','"+strUserAnswer+"','"+strUserQq+"','"+strUserIcq+"','"+strUserMsn+"')"; 
==
给了10个字段，但只传了9个值还有，从常理来说，界面上有两个Password是防止用户输入错误，但数据库只应该存放一个Password