This is my code in .aspx file i write:
<asp:GridView ID="grd" runat="server" AutoGenerateColumns="false" OnRowDataBound="grd_RowDataBound" Width="100%" CssClass="grid-view">
<columns>
<asp:TemplateField HeaderText="Company Name">
<itemtemplate>
<asp:Label ID="lblCompanyName" runat="server" Text='<%# Eval("CompanyName") %>'>
<%-- <asp:Label ID="Label1" runat="server" Text='<%# Eval("FromDate","{0:dd-MMM-yyyy}") %>'>
<asp:Label ID="Label2" runat="server" Text='<%# Eval("ToDate","{0:dd-MMM-yyyy}") %>'>--%>
<edititemtemplate>
<asp:TemplateField HeaderText="View/Update">
<itemtemplate>
<asp:ImageButton ID="imgBtnshow" runat="server" CausesValidation="false"
CommandArgument='<%# Eval("InsuranceId") %>' ImageUrl="~/Images/buttonedit.png" onclick="imgBtnshow_Click" />
<edititemtemplate>
<asp:ImageButton ID="imgBtnEdit" runat="server" CommandArgument='<%# Eval("InsuranceId") %>' ImageUrl="~/Images/buttonsave.png" OnClick="imgBtnEdit_Click" ValidationGroup="WarehouseUpdate" />
<asp:ImageButton ID="imgBtnCancel" runat="server"
ImageUrl="~/Images/1350368827_save_delete.png" onclick="imgBtnCancel_Click"/>
<HeaderStyle Width="50px" />
<ItemStyle Width="50px" />
<asp:TemplateField HeaderText="Delete">
<itemtemplate>
<asp:ImageButton ID="imgBtnDelete" runat="server" CommandArgument='<%# Eval("InsuranceId") %>' ImageUrl="~/Images/buttondelete.png" OnClick="imgBtnDelete_Click" OnClientClick="return confirm('Are you sure to delete this Record.')"/>
<%--ValidationGroup="Insurance"--%>
<HeaderStyle Width="50px" Horizontal VerticalAlign="Middle" />
<ItemStyle Width="50px" HorizontalAlign="Center" VerticalAlign="Top" />
And i write this code in .aspx.cs file on imgBtnDelete_Click event:
protected void imgBtnDelete_Click(object sender, ImageClickEventArgs e)
{
string confirmValue = Request.Form["confirm_value"];
if (confirmValue == "Yes")
{
ImageButton btn = (ImageButton)sender;
Int64 Id = Convert.ToInt64(btn.CommandArgument);
InsuranceCompany obj = new InsuranceCompany();
obj.InsuranceCompanyId = Id;
int result = obj.InsuranceCompanyDelete(Id);
if (result > 0)
{
string popupScript = "$.prompt('Record Deleted Successfully.');";
ScriptManager.RegisterClientScriptBlock(this.Page, this.Page.GetType(), "clientScript", popupScript, true);
fillgrid();
}
}
What I have tried:
but this code not delete data from database and i dont know how to do it and what i do know now. where is problem in my code. how to i solve it.
here in this project we use stored procedure to delete data and bussinessLogicLayer where we difine this