สอบถามปัญหาเรื่อง GridView RowEditing เมื่อกดปุ่ม Edit แล้วเกิด Row ว่าง 1 บรรทัด ซึ่งไม่ใช่บรรทัดที่ต้องการแก้ไขข้อมูล

 string strPreviousRowID = string.Empty;
    int intSubTotalIndex = 1;
    double dblSubTotalAmount = 0;
    double dblGrandTotalAmount = 0;

private void LoadGrid()
    {
        double TotalAudit = 0.0;
        double TotalMarketing = 0.0;

        DataTable dt = (DataTable)Session["gvDesc"];
        if (dt.Rows.Count > 0)
        {
            dt.DefaultView.Sort = "FundType";
            gvDesc.DataSource = dt;
            gvDesc.DataBind();
            foreach (DataRow dr in dt.Rows)
            {
                if (dr["FundType"].ToString() == "Current Year Audit Fund")
                {
                    TotalAudit = TotalAudit + Convert.ToDouble(dr["Amount"]);
                }
                else
                {
                    TotalMarketing = TotalMarketing + Convert.ToDouble(dr["Amount"]);
                }
            }
            btnCreate.Visible = true;
            Session["gvDesc"] = dt.DefaultView.ToTable();
        }
        else
        {
            gvDesc.DataSource = dt;
            gvDesc.DataBind();
            btnCreate.Visible = false;
        }
        dt = null;
     }

protected void gvDesc_RowEditing(object sender, GridViewEditEventArgs e)
    {
        gvDesc.EditIndex = e.NewEditIndex;
        LoadGrid();
    }

protected void gvDesc_RowCreated(object sender, GridViewRowEventArgs e)
    {
        bool IsSubTotalRowNeedToAdd = false;
        bool IsGrandTotalRowNeedToAdd = false;

        if ((strPreviousRowID != string.Empty) && (DataBinder.Eval(e.Row.DataItem, "FundType") != null))
            if (strPreviousRowID != DataBinder.Eval(e.Row.DataItem, "FundType").ToString())
                IsSubTotalRowNeedToAdd = true;

        if ((strPreviousRowID != string.Empty) && (DataBinder.Eval(e.Row.DataItem, "FundType") == null))
        {
            IsSubTotalRowNeedToAdd = true;
            IsGrandTotalRowNeedToAdd = true;
            intSubTotalIndex = 0;
        }

        if (IsSubTotalRowNeedToAdd)
        {
            GridView grdViewProducts = (GridView)sender;

            // Creating a Row
            GridViewRow SubTotalRow = new GridViewRow(0, 0, DataControlRowType.DataRow, DataControlRowState.Insert);

            //Adding Total Cell 
            TableCell HeaderCell = new TableCell();
            HeaderCell.Text = "Total :";
            HeaderCell.HorizontalAlign = HorizontalAlign.Right;
            HeaderCell.ColumnSpan = 6; // For merging first, second row cells to one
            HeaderCell.CssClass = "txtBold";
            SubTotalRow.Cells.Add(HeaderCell);

            //Adding Total Amount Column
            HeaderCell = new TableCell();
            HeaderCell.Text = string.Format("{0:#,###.00}", dblSubTotalAmount);
            HeaderCell.HorizontalAlign = HorizontalAlign.Center;
            HeaderCell.CssClass = "txtBold";
            SubTotalRow.Cells.Add(HeaderCell);

            //Adding the Row at the RowIndex position in the Grid
//*** ปัญหาอยู่ตรงนี้ค่ะ ถ้าปิดบรรทัดนี้ไป จะไม่เกิดปัญหา แต่ข้อมูล Total ก็จะไม่แสดงด้วยเช่นกันค่ะ ***//
            grdViewProducts.Controls[0].Controls.AddAt(e.Row.RowIndex + intSubTotalIndex, SubTotalRow);
            intSubTotalIndex++;

            dblSubTotalAmount = 0;
        }
        if (IsGrandTotalRowNeedToAdd)
        {
            GridView grdViewProducts = (GridView)sender;

            // Creating a Row
            GridViewRow GrandTotalRow = new GridViewRow(0, 0, DataControlRowType.DataRow, DataControlRowState.Insert);

            //Adding Grand Total Cell 
            TableCell HeaderCell = new TableCell();
            HeaderCell.Text = "<br/>Grand Total :";
            HeaderCell.HorizontalAlign = HorizontalAlign.Right;
            HeaderCell.ColumnSpan = 6; // For merging first, second row cells to one
            HeaderCell.CssClass = "txtBold";
            GrandTotalRow.Cells.Add(HeaderCell);

            //Adding Total Revenue Column
            HeaderCell = new TableCell();
            HeaderCell.Text = "<br/>" + string.Format("{0:#,###.00}", dblGrandTotalAmount);
            HeaderCell.HorizontalAlign = HorizontalAlign.Center;
            HeaderCell.CssClass = "txtBold";
            GrandTotalRow.Cells.Add(HeaderCell);

            //Adding the Row at the RowIndex position in the Grid
            grdViewProducts.Controls[0].Controls.AddAt(e.Row.RowIndex, GrandTotalRow);
        }
    }

    protected void gvDesc_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            strPreviousRowID = DataBinder.Eval(e.Row.DataItem, "FundType").ToString();
            double dblAmount = Convert.ToDouble(DataBinder.Eval(e.Row.DataItem, "Amount").ToString());
            dblSubTotalAmount += dblAmount;
            dblGrandTotalAmount += dblAmount;

            if (strPreviousRowID == "Current Year Audit Fund")
            {
                lblTotalAudit.Text = string.Format("{0:#,###.00}", dblSubTotalAmount);
            }
            else
            {
                lblTotalMarketing.Text = string.Format("{0:#,###.00}", dblSubTotalAmount);
            }

            Label lblActionCode = (Label)e.Row.FindControl("lblActionCode");
            if (lblActionCode != null)
            {
                if (Convert.ToString(DataBinder.Eval(e.Row.DataItem, "FundType")) == "Current Year Audit Fund")
                {
                    lblActionCode.Text = Session["ActionCode1"].ToString();
                }
                else
                {
                    lblActionCode.Text = Session["ActionCode2"].ToString();
                }
            }

            HiddenField hdfID = (HiddenField)e.Row.FindControl("hdfID");
            LinkButton lbtnContact = (LinkButton)e.Row.FindControl("lbtnContact");
            Button btnEdit = (Button)e.Row.FindControl("btnEdit");
            if (Session["DataContact"] != null)
            {
                lbtnContact.Visible = false;
                DataTable dtDataContact = (DataTable)Session["DataContact"];
                for (int i = 0; i < dtDataContact.Rows.Count; i++)
                {
                    string AssetID = dtDataContact.Rows[i]["AssetID"].ToString();
                    if (hdfID.Value == AssetID)
                    {
                        lbtnContact.Visible = true;
                        btnEdit.Visible = false;
                        break;
                    }
                    else
                    {
                        lbtnContact.Visible = false;
                    }
                }
            }
            else
            {
                lbtnContact.Visible = false;
            }
        }
    }