数据网格控制 [英] datagrid control

问题描述

嗨.. !!

我无法更改所选行的值，即当我单击第一行第二页的编辑按钮时，浏览器再次显示1页&选择1行

代码写在下面

hi..!!

i m not able to change the value of selected row i.e as when i click on edit button of second page of first row the browser again shows 1page & select 1 row

the code is written below

protected void Page_Load(object sender, EventArgs e)
    {
        try
        {
string sqlstr = "select O.Order_ID,O.Package_ID,SC.Package_Name,SC.Package_ID,O.Remarks,O.Original_Quote_Amount,O.Revised_Quote_Amount,O.Amount_Received from tbl_mst_Order O,tbl_mst_Service_Catalogue SC where O.Package_ID=SC.Package_ID";
            da = new SqlDataAdapter(sqlstr, conn);
            da.Fill(ds, "tbl_mst_Order");
            Gdordermgmt.DataSource = ds.Tables["tbl_mst_Order""];
            Gdordermgmt.DataBind();

            }
        catch (Exception ex)
        {

        }
        finally
        {
            conn.Close();
        }

    }

protected void Gdordermgmt_PageIndexChanged(object sender, DataGridPageChangedEventArgs e)
    {
        Gdordermgmt.CurrentPageIndex = e.NewPageIndex;
          Gdordermgmt.DataBind();
}
protected void Gdordermgmt_editcmd(object sender, DataGridCommandEventArgs e)
    {

        Gdordermgmt.EditItemIndex = e.Item.ItemIndex;
        Gdordermgmt.DataBind();
       }
protected void Gdordermgmt_cancelcmd(object sender, DataGridCommandEventArgs e)
   {
       Gdordermgmt.EditItemIndex = -1;
Gdordermgmt.DataBind();
}

protected void Gdordermgmt_updatecmd(object sender, DataGridCommandEventArgs e)
    {
        TextBox txtamtrecieved = (TextBox)e.Item.FindControl("txtamtrecieved");
        TextBox txtrevisedqtamt = (TextBox)e.Item.FindControl("txtrevisedqtamt");
        CheckBox chkdone = (CheckBox)e.Item.FindControl("chkdone");
        CheckBox chkstrtprocess = (CheckBox)e.Item.FindControl("chkstrtprocess");
        cmd.CommandText = "Update tbl_mst_Order" +
                         " Set Revised_Quote_Amount= ''" + txtrevisedqtamt.Text + "'', Received_Amount=''" + txtamtrecieved + "''where Order_ID=''"+ e.Item.ItemIndex +"''";
        cmd.ExecuteNonQuery();
        Gdordermgmt.EditItemIndex = -1;
    }

推荐答案

您错过了IsPostback检查页面加载的权限.

You missed IsPostback check in your page load.

 if(!IsPostback)
 {
  try
  {
     string sqlstr = "select O.Order_ID,O.Package_ID,SC.Package_Name,SC.Package_ID,O.Remarks,O.Original_Quote_Amount,O.Revised_Quote_Amount,O.Amount_Received from tbl_mst_Order O,tbl_mst_Service_Catalogue SC where O.Package_ID=SC.Package_ID";
     da = new SqlDataAdapter(sqlstr, conn);
     da.Fill(ds, "tbl_mst_Order");
     Gdordermgmt.DataSource = ds.Tables["tbl_mst_Order&quot"];
     Gdordermgmt.DataBind();
  }
  catch (Exception ex)
  {
  }
  finally
  {
     conn.Close();
  }
 }

这篇关于数据网格控制的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！