Delete Row From Gridview On Click Of Delete Link In A Column

[sudhashekhar30]

HI all
I am using gridview. i have added a column "delete" in gridview through wizard. i want to delete record on the click of respective delete link.
------------inline code---------

<asp:GridView ID="GridView1" runat="server" OnSelectedIndexChanged="GridView1_SelectedIndexChanged">
        <Columns>
            <asp:CommandField ShowDeleteButton="True" />
        </Columns>
    </asp:GridView>

-----------------------------------------------
i need coding for code behind .
thanks
regards
sudha

[nateraaaa]

Have you searched Google yet? I know there are many useful examples that include the html and the code behind.

Nathan

[Saad Alam]

I recommend you to set DataKeyNames property (Example: Give primary key column name) in that way you will retrieve primary key to perform deletion, after that you will need to add a RowDeleting event. In that event handler you have to add a code similar to this:

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
//First Retrieve Primary Key
Int id = GridView1.DataKeyNames(e.RowIndex);
//Here You will perform deletion simply hit a delete query to the database using the  //id that you have retrieved
DeleteRow();
//Rebind data to updated data
GridView1.DataSource=GetUpdatedData();
GridView1.DataBind();
}

[Frinavale]

Please review the Tutorial on how to use the GridView control found on MSDN here.

Thanks

-Frinny