Unable to delete a gridview row using command event

Question

0.00/5 (No votes)

See more:

ASP.NET

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Emp.aspx.cs" Inherits="Test17716.Emp" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
        <div>
            <table>
                <tr>
                    <td>Name</td>
                    <td>
                        <asp:TextBox ID="txtname" runat="server"></asp:TextBox></td>
                </tr>
                <tr>
                    <td>Address</td>
                    <td>
                        <asp:TextBox ID="txtaddress" runat="server"></asp:TextBox></td>
                </tr>
                <tr>
                    <td>Qualification</td>
                    <td>
                        <asp:DropDownList ID="ddlqualification" runat="server">
                            <%-- <asp:ListItem Text="mca" Value="1"></asp:ListItem>
                            <asp:ListItem Text="mba" Value="2"></asp:ListItem>
                            <asp:ListItem Text="b.tech" Value="3"></asp:ListItem>
                            <asp:ListItem Text="bca" Value="4"></asp:ListItem>--%>
                        </asp:DropDownList></td>
                </tr>
                <tr>
                    <td>Gender</td>
                    <td>
                        <asp:RadioButtonList ID="rdbGender" runat="server" RepeatColumns="2">
                            <%--<asp:ListItem Text="MALE" Value="1"></asp:ListItem>--%>
                        </asp:RadioButtonList></td>
                </tr>
                <tr>
                    <td>Hobies</td>
                    <td>
                        <asp:CheckBoxList ID="Chklist" runat="server" RepeatColumns="3"></asp:CheckBoxList></td>
                </tr>
                <tr>
                    <td>Files</td>
                    <td>
                        <asp:FileUpload ID="fufile" runat="server"></asp:FileUpload></td>
                </tr>
                <tr>
                    <td></td>
                    <td>
                        <asp:Button ID="btnsave" runat="server" Text="Save" OnClick="btnsave_Click" /></td>
                </tr>
                <tr>
                    <td></td>
                    <td>
                        <asp:GridView ID="grd" DataKeyNames="Eid" runat="server"  OnRowCommand="grd_RowCommand" AutoGenerateColumns="False">
                            <Columns>

                                <asp:TemplateField HeaderText="Name">
                                    <ItemTemplate>
                                        <a href="employeeDtaials.aspx?Eid=<%#Eval("Eid") %>"><%#Eval("Name") %></a>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Address">
                                    <ItemTemplate>
                                        <%#Eval("Address") %>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Qualification">
                                    <ItemTemplate>
                                        <%#Eval("QName") %>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Gender">
                                    <ItemTemplate>
                                        <%#Eval("Gender") %>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Hobbies">
                                    <ItemTemplate>
                                        <%#Eval("Hobbies") %>
                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="FileName">
                                    <ItemTemplate>
                                        <%--<a href="/KB/answers/employeeDtaials.aspx"?Eid=<%#Eval("Eid") %>">--%>
                                            <img src="/Files/<%#Eval("FileName") %>" style="width: 50px">
                                        </a>

                                        &nbsp;&nbsp;

                                    </ItemTemplate>
                                </asp:TemplateField>
                                <asp:TemplateField HeaderText="Action">
                                    <ItemTemplate>
                                        <asp:LinkButton ID="lnkEdit" Text="View" CommandArgument='<%#Eval("Eid") %>' CommandName="EDT" runat="server"></asp:LinkButton>
                                        <asp:LinkButton ID="lnkDelete" Text="Delete" CommandArgument='<%#Eval("Eid") %>' CommandName="DEL" runat="server"></asp:LinkButton>
                                        
                                    </ItemTemplate>

                                </asp:TemplateField>
                            </Columns>
                        </asp:GridView>
                    </td>
                </tr>


            </table>

        </div>
    </form>
</body>
</html>

CS Code goes here:

C#

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using System.Configuration;
using System.IO;

namespace Test17716
{
    public partial class Emp : System.Web.UI.Page
    {
        SqlCommand cmd;
        SqlDataAdapter da;
        SqlDataReader dr;
        SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings["abc"].ConnectionString);
        protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
               Fill_Qualification();
               RdbBind();
               Hobies();
               fill_Grid();
            }
        }

        public void Fill_Qualification()
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("usp_Qualification_Select", con);
            cmd.CommandType = CommandType.StoredProcedure;
            DataSet ds = new DataSet();
            SqlDataAdapter sdr = new SqlDataAdapter(cmd);
            sdr.Fill(ds);
            if (ds.Tables[0].Rows.Count > 0)
            {
                ddlqualification.DataValueField = "QID";
                ddlqualification.DataTextField = "QName";
                ddlqualification.DataSource = ds;
                ddlqualification.DataBind();
                ddlqualification.Items.Insert(0,new ListItem("--Select--","0"));
            }
            con.Close();
        }

        public void Hobies()
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("Myhobies", con);
            cmd.CommandType = CommandType.StoredProcedure;
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(ds);
            if (ds.Tables[0].Rows.Count > 0)
            {
                Chklist.DataValueField = "HID";
                Chklist.DataTextField = "HobiesNAme";
                Chklist.DataSource = ds;
                Chklist.DataBind();

            }
            con.Close();
        }

        public void RdbBind()
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("GenderBind", con);
            cmd.CommandType = CommandType.StoredProcedure;
            DataSet ds = new DataSet();
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            da.Fill(ds);
            if (ds.Tables[0].Rows.Count > 0)
            {
                rdbGender.DataValueField = "GID";
                rdbGender.DataTextField = "GName";
                rdbGender.DataSource = ds;
                rdbGender.DataBind();
               
            }
            con.Close();
        }
        public void fill_Grid()
        {
            con.Open();
            SqlCommand cmd = new SqlCommand("usp_Emp_Get", con);
            cmd.CommandType = CommandType.StoredProcedure;
            DataSet ds = new DataSet();
            SqlDataAdapter sdr = new SqlDataAdapter(cmd);
            sdr.Fill(ds);
            if (ds.Tables[0].Rows.Count > 0)
            {
                grd.DataSource = ds;
                grd.DataBind();
            }
            con.Close();
        }

        protected void btnsave_Click(object sender, EventArgs e)
        {
            string HOB = "";
            for (int i = 0; i < Chklist.Items.Count; i++)
            {
                if (Chklist.Items[i].Selected == true)
                {
                    HOB += Chklist.Items[i].Text + ",";
                }
            }
            HOB = HOB.TrimEnd(',');

            string FN = Path.GetFileName(fufile.PostedFile.FileName);
            fufile.SaveAs(Server.MapPath("Files" + "\\" + FN));

            con.Open();
            SqlCommand cmd = new SqlCommand("usp_Emp_Insert", con);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@Name", txtname.Text);
            cmd.Parameters.AddWithValue("@Address", txtaddress.Text);
            cmd.Parameters.AddWithValue("@Qualification", ddlqualification.SelectedValue);
            cmd.Parameters.AddWithValue("@GID", rdbGender.SelectedValue);
            cmd.Parameters.AddWithValue("@Hobbies", HOB);
            cmd.Parameters.AddWithValue("@FileName", FN);
            cmd.ExecuteNonQuery();
            con.Close();
            fill_Grid();

            txtaddress.Text = "";
            txtname.Text = "";

        }

        protected void grd_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            if (e.CommandName == "DEL")
            {
                  con.Open();
                  LinkButton lnkbtn = sender as LinkButton;
                  GridViewRow grdRow = lnkbtn.NamingContainer as GridViewRow;
                  string EmpId = grd.DataKeys[grdRow.RowIndex].Value.ToString();
                
                
                cmd = new SqlCommand("sp_Emp_Delete",con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@Id", EmpId);
                
                cmd.ExecuteNonQuery();
                con.Close();
            }
            else
            {

            }

            }
           
        }

        
    }

Please help me. I am confused how to use GridView Row command event.

What I have tried:

I have used grid view row command event but i am unable to delete the row.

Posted 20-Aug-16 2:32am

Adityakumar2318

Updated 22-Aug-16 7:38am

Add a Solution

Comments

Karthik_Mahalingam 20-Aug-16 8:38am

Please dont dump the code.
add only the portion of code which is related to your issue, so that users will look into it.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

njammy · Accepted Answer · 2016-08-21T23:42:00

Ok so what you need to do is inside your method

C#

protected void grd_RowCommand(object sender, GridViewCommandEventArgs e)

..after the delete is executed, immediately re-bind the grid control to the updated data set.

Your page load only binds the first time page loads, so this is ok for users seeing the page for the first time. Postback commands like you "DEL" should refresh controls within before the method exits.

Vincent Maverick Durano · Accepted Answer · 2016-08-22T07:38:00

Call your fill_Grid() method after executing delete to reflect the changes you've made in your GridView.

C#

protected void grd_RowCommand(object sender, GridViewCommandEventArgs e){
            if (e.CommandName == "DEL")
            {
                  con.Open();
                  LinkButton lnkbtn = sender as LinkButton;
                  GridViewRow grdRow = lnkbtn.NamingContainer as GridViewRow;
                  string EmpId = grd.DataKeys[grdRow.RowIndex].Value.ToString();
                
                
                cmd = new SqlCommand("sp_Emp_Delete",con);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.AddWithValue("@Id", EmpId);
                
                cmd.ExecuteNonQuery();
                con.Close();

                fill_Grid();//this will repopulate your grid with the changes
            }
}

I would also suggest you to debug your code. Set a break point at RowCommand event, then step into your codes to figure out what's happening.

Unable to delete a gridview row using command event

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0