他老说我cm.ExecuteNonQuery(); INSERT INTO 语句错误啊!!
private void Button1_Click(object sender, System.EventArgs e)
{
if (Page.IsValid)
{
strConnection="Provider=Microsoft.Jet.OleDb.4.0;";
strConnection+=@"Data Source=d:\\web\\Dataset\\db\\data.mdb";
Conn=new OleDbConnection(strConnection);
Conn.Open();
string strOb = "insert into User (txtname,txtpw,txtzt,txtcontent) values
(@name,@pw,@zt,@content)";
OleDbCommand cm = new OleDbCommand(strOb,Conn);
cm.Parameters.Add(new OleDbParameter("@name",OleDbType.VarChar,20));
cm.Parameters.Add(new OleDbParameter("@pw",OleDbType.VarChar,20));
cm.Parameters.Add(new OleDbParameter("@zt",OleDbType.VarChar,50));
cm.Parameters.Add(new OleDbParameter("@content",OleDbType.VarChar,255));
cm.Parameters["@name"].Value = txtname.Text;
cm.Parameters["@pw"].Value = txtpw.Text;
cm.Parameters["@zt"].Value = txtzt.Text;
cm.Parameters["@content"].Value = txtcontent.Text;
cm.ExecuteNonQuery();
Conn.Close();
Response.Redirect("WebForm2.aspx");
}
}
请高手们帮我看看啊..谢谢..