.net运行错误问题

[liaoningbxj]

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

[tautaulee]

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

[叶子]

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+"'
)"; 

参数确实少一个 ！

[amandag]

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