How to delete data from database using gridview in ASP.NET

Question

1.00/5 (1 vote)

See more:

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>

Company Name:	<asp:TextBox ID="txtCompanyName" runat="server" Text='<%# Eval("CompanyName") %>'> <asp:RequiredFieldValidator ID="rfvCompanyName" runat="server" ControlToValidate="txtCompanyName" SetFocusOnError="true" ErrorMessage="*" ValidationGroup="Insurance">
Burglary Policy Number :	<asp:TextBox ID="txtBurglaryPolicyNumber" runat="server" Text='<%# Eval("BurglaryPolicyNumber") %>'> <asp:RequiredFieldValidator ID="rfvPolicyNumber" runat="server" ControlToValidate="txtBurglaryPolicyNumber" SetFocusOnError="true" ErrorMessage="*" ValidationGroup="Insurance">
Burglary Cover Amount:	<asp:TextBox ID="txtBurglaryCoverAmount" runat="server" Text='<%# Eval("BurglaryCoverAmount") %>'> <asp:RequiredFieldValidator ID="rfvCoverAmount" runat="server" ControlToValidate="txtBurglaryCoverAmount" SetFocusOnError="true" ErrorMessage="*" ValidationGroup="Insurance">
Fire Policy Number :	<asp:TextBox ID="txtFirePolicyNumber" runat="server" Text='<%# Eval("FirePolicyNumber") %>'> <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtFirePolicyNumber" SetFocusOnError="true" ErrorMessage="*" ValidationGroup="Insurance">
Fire Cover Amount:	<asp:TextBox ID="txtFireCoverAmount" runat="server" Text='<%# Eval("FireCoverAmount") %>'> <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="txtBurglaryCoverAmount" SetFocusOnError="true" ErrorMessage="*" ValidationGroup="Insurance">
From Date :	<asp:TextBox ID="txtFromDate" runat="server" Text='<%# Eval("FromDate") %>'> <cc1:CalendarExtender ID="CalDate" runat="server" TargetControlID="txtFromDate" Format="MM/dd/yyyy"> <asp:RequiredFieldValidator ID="rfvFromDate" runat="server" ControlToValidate="txtFromDate" SetFocusOnError="true" ErrorMessage="*" ValidationGroup="Insurance">
To Date :	<asp:TextBox ID="txtToDate" runat="server" Text='<%# Eval("ToDate") %>'> <cc1:CalendarExtender ID="CalendarExtender1" runat="server" TargetControlID="txtToDate" Format="MM/dd/yyyy"> <asp:RequiredFieldValidator ID="rfvTodate" runat="server" ControlToValidate="txtToDate" SetFocusOnError="true" ErrorMessage="*" ValidationGroup="Insurance">

<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:

C#

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();
            //Response.Redirect("~/Admin/InsuranceCompany.aspx");
        }
}

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

Posted 19-Apr-18 0:32am

Deekshaa Singh Chauhan

Updated 1-May-18 21:44pm

v4

Add a Solution

Comments

F-ES Sitecore 19-Apr-18 6:51am

Does imgBtnDelete_Click get called?
What is in confirmValue?
What is in Id?
What is in result?
Does InsuranceCompanyDelete work?
Do you have a row in your database that matches that id?

Deekshaa Singh Chauhan 19-Apr-18 7:33am

yes i have insuranceId as id and i have data wich is show in gridview bt that not delete

2 solutions

Solution 1

Hello Deekshaa,

With the code sample you provided, other programmers cannot know what your InsurranceCompany object implements.

 InsuranceCompany obj = new InsuranceCompany();
...
obj.InsuranceCompanyDelete(Id);

We could assume that your object's "InsuranceCompanyDelete" method is in fact performing the necessary steps to connect to your DB and execute the appropriate delete statement using the "Id" you have provided. But, assume is all we can do.

Suggestions:

a) Make sure you are in fact passing a valid Id to your InsuranceCompanyDelete method.
b) Verify that said method is actually connecting to your DB and executing the expected delete statement.

Cheers!

Posted 20-Apr-18 4:52am

alexvw

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)

Deekshaa Singh Chauhan · Accepted Answer · 2018-05-01T21:46:00

Now it is working, I have made these changes here:-

In .aspx file:

<asp:GridView ID="grd" runat="server" AutoGenerateColumns="False" OnRowDataBound="grd_RowDataBound" Width="100%" CssClass="grid-view" OnRowDeleting="grd_RowDeleting" DataKeyNames="InsuranceId">
 
<asp:TemplateField HeaderText="Delete">
<itemtemplate>
<asp:ImageButton ID="btnDelete" runat="server" AlternateText="Delete" CommandName="Delete" CommandArgument='<%# Eval("InsuranceId") %>' ImageUrl="~/Images/buttondelete.png" CausesValidation="false" >
</itemtemplate>

In .aspx.cs file:

protected void grd_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
bool IsDeleted = false;
try
{
//int InsuranceId = Convert.ToInt32(grd.DataKeys[e.RowIndex].Value.ToString());
int InsuranceId = Convert.ToInt32(grd.DataKeys[e.RowIndex].Values[0]);
string constr = WebConfigurationManager.ConnectionStrings["WarehouseWebsiteString"].ConnectionString;
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand cmd = new SqlCommand("DELETE FROM tblInsuranceCompany WHERE InsuranceId = @InsuranceId"))
{
cmd.Parameters.AddWithValue("@InsuranceId", InsuranceId);
cmd.Connection = con;
con.Open();
IsDeleted = cmd.ExecuteNonQuery() > 0;
con.Close();
}
fillgrid();
}
}
catch(Exception ex)
{}
if (IsDeleted)
{
//record has been deleted successfully!
//call here gridview bind method and replace it..
ScriptManager.RegisterStartupScript(this, this.GetType(), "alert", "alert('Page Succesfully deleted');window.location ='InsuranceCompany.aspx';", true); ;
fillgrid();
}
else
{
}