菜鸟问题，请帮忙看看到底哪里出问题了？？？

[Alexwinter]

private void Button1_Click(object sender, System.EventArgs e)
{
OleDbConnection cn = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;Data Source="+Server.MapPath("db2.mdb"));

OleDbCommand cm = new OleDbCommand("insert into userinfo1 (name) value (?name)",cn);

cn.Open();
cm.Parameters.Add(new OleDbParameter("?name",OleDbType.Char,10));
cm.ExecuteNonQuery();
cn.Close();
}

[udonome]

参数没有赋值

[udonome]

cm.Parameters[0].value = 你要赋的值

[freemanor]

是不是这儿出了问题：
OleDbCommand cm = new OleDbCommand("insert into userinfo1 (name) value (?name)",cn);

用
OleDbCommand cm = new OleDbCommand("insert into userinfo1 (name) value ('"+ name +"')",cn);
cn.Open();
cm.Parameters.Add(new OleDbParameter("name",OleDbType.Char,10));
cm.ExecuteNonQuery();
cn.Close();


试试

[sjc0]

我把你的试了试
你把他还原
SqlConnection cn = new SqlConnection("server=localhost;database=linpcontract;uid=sa;pwd=;");

SqlCommand cm = new SqlCommand("insert into userinfo1 (name) values (@name)",cn);

cn.Open();
cm.Parameters.Add("@name", SqlDbType.Char).Value = "你的值";
cm.ExecuteNonQuery();
cn.Close();
//好了

[Alexwinter]

谢谢大家,我本来有赋值的,忘写上了;
SQL的我懂啊!!我问的是Access的啊!!
-----------------------------------------
OleDbConnection conn = new OleDbConnection("Provider = Microsoft.Jet.OLEDB.4.0;Data Source = "+Server.MapPath("db2.mdb"));
OleDbCommand cmm = new OleDbCommand("insert into userinfo (username,password) values (?username,?password)",conn);
conn.Open();
cmm.Parameters.Add(new OleDbParameter("?username",OleDbType.Char,20)).Value = username.Text;
cmm.Parameters.Add(new OleDbParameter("?password",OleDbType.Char,20)).Value = password.Text;
cmm.ExecuteNonQuery();
conn.Close();
-----------------------------------------
提示:INSERT INTO 语句的语法错误。
我看不出INSERT INTO哪里错了啊??大家帮帮忙啊???