how to delete data from database using gridview in asp.net

Deekshaa Singh Chauhan

8y1.4k.NET

This is my code in .aspx file i write:

<%--

--%>

Company Name:
Burglary Policy Number :
Burglary Cover Amount:
Fire Policy Number :
Fire Cover Amount:
From Date :
To Date :

CommandArgument='<%# Eval("InsuranceId") %>' ImageUrl="~/Images/buttonedit.png" onclick="imgBtnshow_Click" />

ImageUrl="~/Images/1350368827_save_delete.png" onclick="imgBtnCancel_Click"/>

<%--ValidationGroup="Insurance"--%>

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();

//Response.Redirect("~/Admin/InsuranceCompany.aspx");

}

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Deekshaa Singh Chauhan8y ago
Now it is working, I have made these changes here:-

In Gridview on .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" >asp:ImageButton>

ItemTemplate>



Columns>

asp:GridView>

asp:TemplateField>

" imageurl="~/Images/buttondelete.png" causesvalidation="false">
In ImageButton .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

{

}
0
Suraj Panigrahi8y ago
try the code snippet provided. hope it helps to fix the issue
0
Suraj Panigrahi8y ago
1. protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) {
2. con = new SqlConnection(ConfigurationSettings.AppSettings["connect"]);
3. cmd.Connection = con;
4. Label lbldeleteID = (Label) GridView1.Rows[e.RowIndex].FindControl("lblstId");
5. cmd.CommandText = "Delete from StudentRecord where StId='" + lbldeleteID.Text + "'";
6. con.Open();
7. cmd.ExecuteNonQuery();
8. con.Close();
9. BindData();
10. }
+1

Deekshaa Singh Chauhan8y ago

InsuranceCompanyDelete() is name of delete stored procedure.

Suraj Panigrahi8y ago

what is the definition of obj.InsuranceCompanyDelete(Id)? If you are using Entity framework, you can use lambda expressions to interact with the DB object to delete th data in the table.