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

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

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".

Thanks Keertti, But i need confirmation before deletion.

Hi Jithil,


use this code:


.aspx code: