On deleting the Row of GridView not working properly

Question

Whenever I delete a row from the gridview which I select to delete, the row above to the selected row gets deleted. Dont know why. Please see my code for deleting.

Code behind for your ref:-

protected void grdPostData_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        bool IsDeleted = false;

        int Id = Convert.ToInt32(grdPostData.DataKeys[e.RowIndex].Value.ToString());
        using (SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultCSRConnection"].ConnectionString))
        {
            using (SqlCommand cmd = new SqlCommand())
            {
                cmd.CommandText = "DELETE FROM tbl_Post WHERE Id=@Id";
                cmd.Parameters.AddWithValue("@Id", Id);
                cmd.Connection = conn;
                conn.Open();
                IsDeleted = cmd.ExecuteNonQuery() > 0;
                conn.Close();
            }
        }
        if (IsDeleted)
        {
            ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Page Succesfully deleted');window.location ='csrposts.aspx';", true);
            grdPostData.DataBind();
        }
        else
        {
            Response.Write("Some error");
        }
    }

Please let me know where I am going wrong. I tried debugging the code and the Id was taking 0.

Gridview bindinf Code:-

  public void BindGrid()
    {
        string strQuery = "Select Id, title, description, Active from tbl_Post Order by ID desc";
        SqlCommand cmd = new SqlCommand(strQuery);
        DataTable dt = GetData(cmd);
        grdPostData.DataSource = dt;
        grdPostData.DataBind();
    }
    private DataTable GetData(SqlCommand cmd)
    {
        DataTable dt = new DataTable();
        SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultCSRConnection"].ConnectionString);
        SqlDataAdapter sda = new SqlDataAdapter();
        cmd.CommandType = CommandType.Text;
        cmd.Connection = conn;
        try
        {
            conn.Open();
            sda.SelectCommand = cmd;
            sda.Fill(dt);
            return dt;
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            conn.Close();
            sda.Dispose();
            conn.Dispose();
        }
    }

ALOK · Accepted Answer

Updated Solution. Completely Working. I am Creating those textboxes in DataBound and theirs a if condition that checks whether Gridview is Empty or Not.
If Gridview is empty then HeaderRow wont be created so that Gridview and Page is able to display else HeaderRow will be Displayed.
Hope this Works for You.

aspx:-

  <%@ Page Title="" Language="C#" MasterPageFile="~/Master.Master" AutoEventWireup="true"
CodeFile="csrposts.aspx.cs" Inherits="CSRProject.csrposts" %>
  
                
                
                    
                    
                    
                        
                            
                                <%-- --%>
                            
                             
                        
                    
                    
                    
                        
                            
                            
                        
                    
                    
                        
                    
                
                
                    No Result Found

Aspx.cs

   protected void grdPostPageData_DataBound(object sender, EventArgs e)
    {

        GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal);
        for (int i = 0; i < grdPostData.Columns.Count; i++)
        {
            TableHeaderCell cell = new TableHeaderCell();
            TextBox txtSearch = new TextBox();
            txtSearch.Attributes["placeholder"] = grdPostData.Columns[i].HeaderText;
            txtSearch.CssClass = "form-control HaydaBre";
            cell.Controls.Add(txtSearch);
            row.Controls.Add(cell);
        }
        if (grdPostData.Rows.Count > 0)
        {
            grdPostData.HeaderRow.Parent.Controls.AddAt(0, row);
        }
        else
        {

        }
    }

    protected void grdPostData_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        /*
        if (e.Row.RowType == DataControlRowType.Header)
        {

            GridViewRow row = new GridViewRow(0, 0, DataControlRowType.Header, DataControlRowState.Normal);
            for (int i = 0; i < grdPostData.Columns.Count; i++)
            {
                TableHeaderCell cell = new TableHeaderCell();
                TextBox txtSearch = new TextBox();
                txtSearch.Attributes["placeholder"] = grdPostData.Columns[i].HeaderText;
                txtSearch.CssClass = "form-control HaydaBre";
                cell.Controls.Add(txtSearch);
                row.Controls.Add(cell);
            }
             grdPostData.HeaderRow.Parent.Controls.AddAt(-1, row);
           // e.Row.Parent.Controls.AddAt(1, row);
        }
        */
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DefaultCSRConnection"].ConnectionString);
            SqlCommand cmd = new SqlCommand("select * from tbl_PostCategory ", conn);
            cmd.CommandType = CommandType.Text;
            SqlDataAdapter da = new SqlDataAdapter();
            da.SelectCommand = cmd;
            DataTable dt = new DataTable();
            da.Fill(dt);

            if (dt.Rows.Count > 0)
            {
                DropDownList DropDownList1 =
                (DropDownList)e.Row.FindControl("ddlPostCategory");
                DropDownList1.DataSource = dt;
                DropDownList1.DataTextField = "cat_title";
                DropDownList1.DataValueField = "cat_title";
                DropDownList1.DataBind();
            }
        }
    }

Row Deleting Code is Same.

On deleting the Row of GridView not working properly

Answers (2)

Related Questions