网格视图在数据绑定上没有刷新 [英] grid view not refreshing on databind

问题描述

我有一个包含2个网格视图的页面



在第一个我可以再选择一行并点击网格外的添加按钮将删除数据从该网格并添加到第二个网格。这部分工作得很好



在第二个网格中，我有一个ImageButton来执行删除操作，这应该从第二个删除数据（这是工作），应该添加这到第一个Grid。本节不起作用。但是如果我刷新页面，第一个网格显示删除的数据。



这里是我的代码

I have a page with 2 grid views

in the first one i can select one more more rows and click on add button outside the grid will remove the data from that grid and add to the second grid. This part is working perfectly

In the second grid,i have an ImageButton to perform remove action , This should remove the data from second (this is working) and should add this to first Grid. This section is not working. But if I refresh the page, the first grid is showing the removed data.

here is my code

protected void gvQCOrder_RowDeleting(object sender, GridViewDeleteEventArgs e)
   {

       int id = Convert.ToInt32(gvQCOrder.DataKeys[e.RowIndex].Value);
       SqlConnection objCon = new SqlConnection(SqlHelper.GetConnection("Conns"));
       SqlTransaction Strac;
       objCon.Open();
       Strac = objCon.BeginTransaction();
       try
       {
           List<SqlParameter> array = new List<SqlParameter>();
           array.Add(new SqlParameter("@QCAuditID", id));

           SqlCommand cmd1 = new SqlCommand("[USP_del_QCOrder]", objCon, Strac);
           int result1 = DAL.executeSaveMultipleQuery(cmd1, CommandType.StoredProcedure, array);

           Strac.Commit();

       }
       catch (Exception ex)
       {
           Strac.Rollback();

       }
       finally
       {
           createdtStructure();
           bindValues();
       }




   }

绑定值代码

code for bind values

private void bindValues()

    {
       if (Session["OrderId"] != null)
       {
           int OrderId = Convert.ToInt32(Session["OrderId"].ToString());

           List<SqlParameter> _params = new List<SqlParameter>();
           _params.Add(new SqlParameter("@OrderId", OrderId));

           DataSet dsQC = DAL.executeDataSet("Usp_OrderDetails", _params, CommandType.StoredProcedure);
            vdtHead = dsQC.Tables[0];
            lblTxtQMS.Text = vdtHead.Rows[0]["QS_Nbr"].ToString();
            lblTxtFiles.Text = vdtHead.Rows[0]["Files_Ordered"].ToString();

            dtAudits = dsQC.Tables[1];
            createdtStructure();
            if (dtAudits.Rows.Count > 0)
            {
                gvOrderMgnt.DataSource = dtAudits;
                gvOrderMgnt.DataBind();
                gvOrderMgnt.SelectedIndex = -1;
            }

            List<SqlParameter> list = new List<SqlParameter>();
            list.Add(new SqlParameter("@OrderId", OrderId));
            DataTable dtId = DAL.executeDataTable("Usp_Check_OrderHeader", list, CommandType.StoredProcedure);
            if (dtId.Rows.Count > 0)
            {
                List<SqlParameter> list1 = new List<SqlParameter>();
                list1.Add(new SqlParameter("@OrderId", Convert.ToInt32(dtId.Rows[0]["ID"].ToString())));
                dtQCAudit = DAL.executeDataTable("usp_QC_OrderDetails", list1, CommandType.StoredProcedure);
                gvQCOrder.DataSource = dtQCAudit;
                gvQCOrder.DataBind();
                if (dtQCAudit.Rows.Count>0)
                    lblQCNo.Text=dtQCAudit.Rows[0]["QC_Nbr"].ToString();
                btnCreate.Visible = false;
                btnDelete.Visible = true;
                btnAdd.Visible = true;
            }
            else
            {
                dtQCAudit = null;
                gvQCOrder.DataSource = dtQCAudit;
                gvQCOrder.DataBind();
                btnCreate.Visible = true;
                btnAdd.Visible = false;
                btnDelete.Visible = false;
            }
       }
   }

请更正我

please correct me

推荐答案

嗨



尝试在Postback后重新绑定网格。

请将其标记为答案，如果它可以解决您的问题。

Hi

Try to rebind the grid after Postback .
Pls mark it as answer if it resolves your problem .

这篇关于网格视图在数据绑定上没有刷新的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！