C# Access 修改数据

Web.config参考上一篇文章

edit_form.aspx.cs

public int id; protected void Page_Load(object sender, EventArgs e) { id = Convert.ToInt16(Request.QueryString["id"].ToString()); if (!IsPostBack) { string connStr = ConfigurationManager.ConnectionStrings["connStr"].ToString(); OleDbConnection conn = new OleDbConnection(connStr); conn.Open(); string sql = "select * from form where id=" + id; OleDbCommand cmd = new OleDbCommand(sql, conn); OleDbDataReader odr = cmd.ExecuteReader(); while (odr.Read()) { gzsx_TextBox.Text = odr["gzsx"].ToString(); fzr_TextBox.Text = odr["fzr"].ToString(); jdr_TextBox.Text = odr["jdr"].ToString(); jhwcsj_TextBox.Text = odr["jhwcsj"].ToString(); sjwcsj_TextBox.Text = odr["sjwcsj"].ToString(); knd_TextBox.Text = odr["knd"].ToString(); wcjg_TextBox.Text = odr["wcjg"].ToString(); } conn.Close(); } } //修改 protected void edit_Button_Click(object sender, EventArgs e) { string connStr = ConfigurationManager.ConnectionStrings["connStr"].ToString(); OleDbConnection conn = new OleDbConnection(connStr); conn.Open(); string sql = "update form set gzsx='" + gzsx_TextBox.Text + "',fzr='" + fzr_TextBox.Text + "',jdr='" + jdr_TextBox.Text + "',jhwcsj='" + jhwcsj_TextBox.Text + "',sjwcsj='" + sjwcsj_TextBox.Text + "',knd='" + knd_TextBox.Text + "',wcjg='" + wcjg_TextBox.Text + "' where id=" + id; OleDbCommand cmd = new OleDbCommand(sql, conn); cmd.ExecuteNonQuery(); Response.Write("<mce:script language=javascript><!-- alert('修改成功。。。。'); // --></mce:script>"); conn.Close(); Response.Write("<mce:script language=javascript><!-- location.href('Default.aspx'); // --></mce:script>"); }