Access数据操作Update方法

using System.Data.OleDb; //这里要引用OleDb空间

 

 

public partial class addInfo : System.Web.UI.Page
{

    //数据库连接字符串
    static string strCon = @"provider = Microsoft.Jet.OLEDB.4.0;Data source = |DataDirectory|gyMDB.mdb";

    //以上方法为连接ACCESS 特定数据目录APP_DATA 下数据文件的方法。注意DATADIRECTORY 的使用。

    //申明连接数据源的对象和对数据源进行操作的对象
    OleDbConnection con = new OleDbConnection(strCon);
    OleDbCommand cmd = new OleDbCommand();

    //点击按钮添加记录

 

 

    protected void Page_Load(object sender, EventArgs e)
    {
        TextBox11.ReadOnly = false;
        TextBox11.Text = "这是学号";
        TextBox11.ReadOnly = true;

        TextBox12.Text = "这是准考证号";
        TextBox13.Text = "这是姓名";

        if (!Page.IsPostBack) { }

    }
    protected void Button1_Click(object sender, EventArgs e)
    {
      
        string A0 = TextBox11.Text; //0.学号
        string A1 = TextBox12.Text; //1.准考证号
        string A2 = TextBox13.Text; //2.姓名
        string A3 = DropDownList1.Text; //3.小学入学年月
        string A4 = DropDownList2.Text; //4.班号
        string A5 = DropDownList3.Text; //5.学生类别
        string A6 = TextBox1.Text.Trim(); //6.身份证号
        string A7 = DropDownList4.Text; //7.性别
        string A8 = TextBox2.Text.Trim(); //8.出生日期
        string A9 = TextBox3.Text.Trim(); //9.出生地
        string A10 = DropDownList5.Text;//10.是否独生子女
        string A11 = TextBox4.Text.Trim(); ; //11.籍贯
        string A12 = DropDownList6.Text; //12.民族
        string A13 = TextBox5.Text.Trim(); //13.户口所在地
        string A14 = DropDownList7.Text; //14.是否农民工子女
        string A15 = DropDownList8.Text; //15.是否贫困生
        string A16 = TextBox6.Text.Trim(); //16.家庭住址
        string A17 = TextBox7.Text.Trim(); //17.家庭邮政编码
        string A18 = TextBox8.Text.Trim(); //18.家庭联系人
        string A19 = DropDownList9.Text; //19.家族联系人关系
        string A20 = TextBox9.Text.Trim();//20.家长姓名
        string A21 = TextBox10.Text.Trim(); ; //21.职业
        string A22 = DropDownList10.Text; ; //22.是否是监护人

    

 

    //    string LBCLASS;
   //     if (RadioButton2.Checked)
  //      {
   //         LBCLASS = RadioButton2.Text;  //3.学校名
  //      }
   //     else
  //      {
  //          LBCLASS = RadioButton3.Text;

  //      }
       

 

        //要插入记录的sql语句
//        string insertText = "insert into ITmdb(A0,A1,A2,A3,A4,A5,A6,A7,A8,A9,A10,A11,A12,A13,A14,A15,A16,A17,A18,A19,A20,A21,A22,A23) values('" + A0 + "','" + A1 + "','" + A2 + "','" + A3 + "','" + A4 + "','" + A5 + "','" + A6 + "','" + A7 + "','" + A8 + "','" + A9 + "','" + A10 + "','" + A11 + "','" + A12 + "','" + A13 + "','" + A14 + "','" + A15 + "','" + A16 + "','" + A17 + "','" + A18 + "','" + A19 + "','" + A20 + "','" + A21 + "','" + A22 + "')";

    
  // 要更新的学生信息
    

 

        string insertText = "update gyMDB SET A3='" +A3+ "',A4='"+A4+"',A5='"+A5+"',A6='"+A6+ "',A7='"+A7+"',A8='"+A8+"',A9='"+A9+"',A10='"+A10+"',A11='"+A11+"',A12='"+A12+"',A13='"+A13+"',A14='"+A14+ "',A15='"+A15+"',A16='"+A16+"',A17='"+A17+"',A18='"+A18+"',A19='"+A19+"',A20='"+A20+"',A21='"+A21+"',A22='"+A22+"' where A0='1'";

//        string insertText = "update gyMDB SET A3='" + A3 + "',A4='" + A4 + "',A5='" + A5 + "',A6='" + A6 + "',A7='" + A7 + "',A8='" + A8 + "',A9='" + A9 + "',A10='" + A10 + "',A11='"+A11+"',A12='" +A12+ "',A15='" + A3 + "',A17='" + A3 + "',A18='" + A3 + "',A19='" + A3 + "',A20='" + A3 + "' where A0='1'";

 
       
       
        //    string insertText = "update gyMDB SET A3='" + this.DropDownList1.Text + "' where A0='1'";   //成功更新代码

        //    string insertText = "update gyMDB SET A3='" + A3 + "' where A0='1'";   //成功更新代码

        //数据源打开EACHER,TJREN,
        con.Open();

        //设置操作对象的数据源
        cmd.Connection = con;

        //要执行的SQL语句
        cmd.CommandText = insertText;

        //执行操作
        cmd.ExecuteNonQuery();

        //数据源关闭
        con.Close();

 

        //加入显示其它网页效果和弹出效果。
        //  Response.Write("<script>alert('删除成功!')</script>");
        // Response.Write("<script language=javascript>window.open('new.aspx');</script>");

        Response.Write("<script>alert('感谢您提交数据//n//n请您查看数据统计');location.href='editinfo.aspx';</script>");

 

    }