Delete data row from sql in a gridview

Question

I am trying to delete data from a gridview using a a link button. I need help with the logic and making the link button remove the row data from the database on click.

GridView

        <asp:GridView Style="width: 100%" ID="GvReportResults" runat="server"                       AutoGenerateColumns="False" EmptyDataText="No data" ShowHeaderWhenEmpty="True">
            <Columns>
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:LinkButton ID="lnkBtnEdit" runat="server" CausesValidation="false" >Edit</asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:TemplateField>
                    <ItemTemplate>
                        <asp:LinkButton ID="LnkBtnRemove" runat="server" CausesValidation="false" CommandName="DeleteItem" CommandArgument='<%# Eval("OtherDataID") %>'>Delete</asp:LinkButton>
                    </ItemTemplate>
                </asp:TemplateField>
                <asp:BoundField DataField="SourceID" HeaderText="ID" />
                <asp:BoundField DataField="LastName" HeaderText="Last Name" />
                <asp:BoundField DataField="FirstName" HeaderText="First Name" />
                <asp:BoundField DataField="MiddleName" HeaderText="Middle Name" />
                <asp:BoundField DataField="Title" HeaderText="Title" />
                <asp:BoundField DataField="NationalID" HeaderText="SSN" />
                <asp:BoundField DataField="DOB" HeaderText="DOB" />
                <asp:BoundField DataField="HireDate" HeaderText="Hire Date" />
                <asp:BoundField DataField="Address1" HeaderText="Address" />
                <asp:BoundField DataField="City" HeaderText="City" />
                <asp:BoundField DataField="State" HeaderText="State" />
                <asp:BoundField DataField="PostalCode" HeaderText="Zip Code" />
            </Columns>
        </asp:GridView>

Store precedure thats importing data to gridview

    private void BindGrid()
{
    //set up arguments for the stored proc
    int? FacilityID = (ddlFacility2.SelectedValue.Equals("-1")) ? (int?)null : int.Parse(ddlFacility2.SelectedValue);
    int? OtherDataID = null;

    //bind
    GvReportResults.DataSource = this.DataLayer.model.MS_spGetOtherData(FacilityID, OtherDataID);
    GvReportResults.DataBind();
}

You can Delete at RowCommand event by adding a command argurment at item template or using Gridview_RowDeleting event Refer this gives u basic idea satindersinght.blogspot.in/2012/08/… — Satinder singh
– Satinder singh, Commented May 28, 2013 at 5:45

Bharadwaj · Accepted Answer · 2013-05-29 11:37:06Z

1

Add OnClick attribute for the LinkButton, for example (added OnClick to your linkbutton code)

<asp:LinkButton ID="LnkBtnRemove" runat="server" CausesValidation="false" CommandName="DeleteItem" CommandArgument='<%# Eval("OtherDataID") %>' OnClick='LnkBtnRemove_Click'>Delete</asp:LinkButton>

Have OnClick listener as

protected void LnkBtnRemove_Click(object sender,EventArgs e)
{
   string id = ((LinkButton)sender).CommandArgument;//CommandArgument is always returns string
   Do_DeleteRow(id);//method to delete
   BindGrid();
}

private void Do_DeleteRow(string id)
{
   //your delete code will be added here
}

edited May 29, 2013 at 11:37

answered May 28, 2013 at 5:38

Bharadwaj

2,5511 gold badge25 silver badges35 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user2425793 Over a year ago

Its erroring out on Do_DeleteRow(ID). Saying does not exist in current context?

Bharadwaj Over a year ago

Do_DeleteRow(ID) is a method that you have to define to delete. Sorry I haven't added that as comment. I will edit this...

gzaxx · Accepted Answer · 2013-05-28 05:23:46Z

0

Just attach ItemCommand event to your grid

On web page in your grid definition add:

<asp:DataGrid OnItemCommand="Grid_ItemCommand" />

after that in code behind:

void Grid_ItemCommand(Object sender, DataGridCommandEventArgs e)
{
    var id = Int32.Parse(e.CommandArgument.ToString()); //use parse if OtherDataID is int

    //here goes logic for deleting row
    this.DataLayer.model.spDeleteData(id);

    //after deleting rebind grid
    BindGrid();
}

edited May 28, 2013 at 5:23

answered May 27, 2013 at 17:27

gzaxx

17.6k2 gold badges40 silver badges55 bronze badges

7 Comments

user2425793 Over a year ago

How will adding a ItemCommand event to gridview make the link button delete the data? Sorry just confused as to where and what I put for the item command event. Thanks

gzaxx Over a year ago

Made some edits to make it more clear. On link button click that event will be fired with information about control clicked, command name and command argument. Just handle deleting there and you will be fine.

user2425793 Over a year ago

It is now giving an error on the "spDeleteData" in the this.DataLayer.model.spDeleteData(id); Saying my model does not contain a defination for deleteData. Also could you possibly show me how to place this event within the onclick event?

gzaxx Over a year ago

That is because it was just an example, you have to create in your model method to delete record from db.

user2425793 Over a year ago

Ok i got that done with a store precedure, Could you show example how to place this into the onclick function?

|

Satinder singh · Accepted Answer · 2013-05-28 06:02:05Z

Convert your boundfiled into Item Template, Here using sourceid will fire delete Query.
Code look like this:

protected void GvReportResults_RowCommand(object sender, GridViewCommandEventArgs e)
 {
    if (e.CommandName == "DeleteItem")
    {
        int getrow = Convert.ToInt32(e.CommandArgument);
        Label lblSourceID = (Label)GvReportResults.Rows[getrow].FindControl("lblSourceID");
        bool flag=deleteRecord(lblSourceID.text);
        if(flag)
        {
         succes msg!
        }
         else{ failed msg}
        }
    }

    public bool deleteRecord(String SourceID)
    {
    try
       {
        SqlCommand cmd = new SqlCommand("Your Delete Query where condtion  ", conn);
        conn.Open();
        cmd.ExecuteNonQuery();
        conn.Close();
        return true;
    }   
    catch(Exception ac)
    {
        return false;
    }

 }

Collectives™ on Stack Overflow

Delete data row from sql in a gridview

3 Answers 3

2 Comments

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related