Deletion in GridView

on Aspx we do this code. and it need a Code Aspx.cs and we don't know that what code we can give on Cs page.please give me some tips about this.


<div>
<asp:GridView DataKeyNames="Catagory_Id" ID="GridView1" CssClass="Grid" Caption="All Catagories"
runat="server" Width="367px" AutoGenerateColumns="true"
OnPageIndexChanging="GridView1_PageIndexChanging"
EnableViewState="true" PageSize="2" PagerSettings-PageButtonCount="5"
AllowPaging="true" BorderStyle="Solid">
<columns>
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="lnk1" runat="server" Text="Delete" OnClientClick="return cofirm('ARE YOU SURE TO DELETE?')" CommandName="Delete" ></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</columns>
</asp:GridView>
<asp:SqlDataSource ID ="SqlDataSource1" runat="server" DeleteCommand= "Delete From Catagory Where Catagory_Id= @Catagory_Id">
<DeleteParameters>
<asp:Parameter Name="Catagory_Id" />
</DeleteParameters>
</asp:SqlDataSource>
<i>you are viewing page
<% =GridView1.PageIndex + 1%>
of
<%=GridView1.PageCount%>

</i>
</div>

Sir on Aspx we give this code. it need code on cs page onRowDeleting. what code we can give on ONRowDeleting in Cs page please give me some tips.


<div>
<asp:GridView DataKeyNames="Catagory_Id" ID="GridView1" CssClass="Grid" Caption="All Catagories"
runat="server" Width="367px" AutoGenerateColumns="true"
OnPageIndexChanging="GridView1_PageIndexChanging"
EnableViewState="true" PageSize="2" PagerSettings-PageButtonCount="5"
AllowPaging="true" BorderStyle="Solid">
<columns>
<asp:TemplateField HeaderText="Delete">
<ItemTemplate>
<asp:LinkButton ID="lnk1" runat="server" Text="Delete" OnClientClick="return cofirm('ARE YOU SURE TO DELETE?')" CommandName="Delete" ></asp:LinkButton>
</ItemTemplate>
</asp:TemplateField>
</columns>
</asp:GridView>
<asp:SqlDataSource ID ="SqlDataSource1" runat="server" DeleteCommand= "Delete From Catagory Where Catagory_Id= @Catagory_Id">
<DeleteParameters>
<asp:Parameter Name="Catagory_Id" />
</DeleteParameters>
</asp:SqlDataSource>
<i>you are viewing page
<% =GridView1.PageIndex + 1%>
of
<%=GridView1.PageCount%>

</i>
</div>

Have you done any research at all ? There's tons of examples on the web. You identify the column you want to delete by it's Id, then you call SQL to delete it.

Wow[^] - would you look at that !!!

plenty of examples there.