ASP.NET实现增删改查等功能(Access版)系统之五-更新

更新方法一，直接在GridView中来更新数据.

更新方法二，打开一个新的页面来更新数据.

//更新

    protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e)

    {

        GridView1.EditIndex = e.NewEditIndex;

        //PopulatePublishersGridView();

        string sqlstr = getSQlStr();

        bind(sqlstr);

    }

 

//更新

    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)

    {

        OleDbConnection sqlcon = new OleDbConnection(GetConnection());

     

        string sqlstr = "update XJ_WY_ZZ set ZZYear='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[4].Controls[0])).Text.ToString().Trim()

             + "',XqGaiZaoYear='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[5].Controls[0])).Text.ToString().Trim()

             + "',DanYuanShu='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[6].Controls[0])).Text.ToString().Trim()

              + "',CengGao='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[7].Controls[0])).Text.ToString().Trim()

             + "',JuMinHuShu='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[8].Controls[0])).Text.ToString().Trim()

             + "',QiangTiJieGou='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[9].Controls[0])).Text.ToString().Trim()

             + "',JianZhuMianJi='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[10].Controls[0])).Text.ToString().Trim()

             + "',SanReQiXingShi='" + ((TextBox)(GridView1.Rows[e.RowIndex].Cells[11].Controls[0])).Text.ToString().Trim() + "'"

             + " where id='" + GridView1.DataKeys[e.RowIndex].Value.ToString() + "'";

        OleDbCommand sqlcom = new OleDbCommand(sqlstr, sqlcon);

        sqlcon.Open();

        //TextBox1.Text = sqlstr;

        sqlcom.ExecuteNonQuery();

        sqlcon.Close();

        GridView1.EditIndex = -1;

        string sqlstr2 = getSQlStr();

        bind(sqlstr2);

        //PopulatePublishersGridView();

    }

//取消

    protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e)

    {

        GridView1.EditIndex = -1;

        //PopulatePublishersGridView();

        string sqlstr = getSQlStr();

        bind(sqlstr);

    }