求救!!数据库INSERT出错,给指点一下!!!
private void Button2_Click(object sender, System.EventArgs e)
{
string strDSN ="Provider=Microsoft.Jet.OLEDB.4.0; Data Source="+Server.MapPath("/WebApplication1/reg2.mdb");
OleDbCommand Cmd;
OleDbConnection Conn;
string strSQL="INSERT INTO reg VALUES('5','"+ TextBox2.Text + "','"+TextBox3.Text + "')";
Conn = new OleDbConnection(strDSN);
Conn.Open();
Cmd = new OleDbCommand();
Cmd.Connection=Conn;
Cmd.CommandText=strSQL;
Cmd.ExecuteNonQuery();
Cmd.Connection.Close();
}
操作必须使用一个可更新的查询。
行 91: Cmd.Connection=Conn;
行 92: Cmd.CommandText=strSQL;
行 93: Cmd.ExecuteNonQuery();
行 94: Cmd.Connection.Close();