To delete a row with co from a grid view usnig button field?

Question

To delete a row with confirmation of data from a grid view using the button field in asp.net

g s · Answer

Button click Before check http://dotnetdrizzles.blogspot.in/2015/03/confirm-message-box-with-ok-or-cancel.html http://screenshotdrizzles.blogspot.in/2015/03/confirm-message-box-with-ok-or-cancel.html Delete gridview Data http://dotnetdrizzles.blogspot.in/2014/09/insertupdatedelete-in-gridview-using.html http://screenshotdrizzles.blogspot.in/2014/10/insertupdatedelete-in-gridview-using.html

Keertti Raj Thangavelu Babu · Answer

Hi, Here is code with confirmation. .cs code public partial class gridview : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { gvbind(); } } protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { SqlConnection connect = new SqlConnection("Data Source=sqlserver;Initial Catalog=DB;Integrated Security=true;"); int empid = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[1].Text); connect.Open(); SqlCommand cmd = new SqlCommand("delete FROM tabelname where columnname= @EmpID", connect); cmd.Parameters.Add("@EmpID", SqlDbType.Int).Value = Convert.ToInt32(empid); int Check = Convert.ToInt32(cmd.ExecuteNonQuery()); connect.Close(); gvbind(); } protected void OnRowDataBound(object sender, GridViewRowEventArgs e) { if (e.Row.RowState != DataControlRowState.Edit) { if (e.Row.RowType == DataControlRowType.DataRow) { LinkButton lb = (LinkButton)e.Row.Cells[0].Controls[0]; if (lb != null) { lb.OnClientClick = "return confirm('You want to delete this data ?');"; } } } } public void gvbind() { SqlConnection connect = new SqlConnection("Data Source=sqlserver;Initial Catalog=DB;Integrated Security=true;"); connect.Open(); SqlCommand scom = new SqlCommand(); scom.Connection = connect; scom.CommandText = "Select * from tabelname"; DataSet ds = new DataSet(); SqlDataAdapter dap = new SqlDataAdapter(); dap.SelectCommand = scom; dap.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); } } ---------------------------------- .aspx code onrowdatabound="OnRowDataBound" onrowdeleting="GridView1_RowDeleting"> code -------------------------------------------------------------------------- If this answer helps you. Please validate as "Accept answer".

Jithil John · Answer

Thanks Keertti, But i need confirmation before deletion.

Keertti Raj Thangavelu Babu · Answer

Hi Jithil, use this code: .aspx code: onrowdeleting="GridView1_RowDeleting"> .cs code: public partial class gridview : System.Web.UI.Page { protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { gvbind(); } } protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) { SqlConnection connect = new SqlConnection("Data Source=sqlserver;Initial Catalog=DB;Integrated Security=true;"); int empid = Convert.ToInt32(GridView1.Rows[e.RowIndex].Cells[1].Text); connect.Open(); SqlCommand cmd = new SqlCommand("delete FROM tabelname where columnname= @EmpID", connect); cmd.Parameters.Add("@EmpID", SqlDbType.Int).Value = Convert.ToInt32(empid); int Check = Convert.ToInt32(cmd.ExecuteNonQuery()); connect.Close(); if (Check != 0) { Response.Write(" alert(\"Row is delete\"); "); } else Response.Write(" alert(\"Row is not delete\"); "); gvbind(); } public void gvbind() { SqlConnection connect = new SqlConnection("Data Source=sqlserver;Initial Catalog=DB;Integrated Security=true;"); connect.Open(); SqlCommand scom = new SqlCommand(); scom.Connection = connect; scom.CommandText = "Select * from tabelname"; DataSet ds = new DataSet(); SqlDataAdapter dap = new SqlDataAdapter(); dap.SelectCommand = scom; dap.Fill(ds); GridView1.DataSource = ds; GridView1.DataBind(); } }

To delete a row with co from a grid view usnig button field?

Answers (4)