Gridview delete row display items confirmation

</asp:TemplateField>

</Columns>

</asp:GridView>

</div>

</form>

</body>

</html>

using System;

using System.Configuration;

using System.Data;

using System.Linq;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.HtmlControls;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Xml.Linq;

using System.Data.SqlClient;

public partial class _Default : System.Web.UI.Page

{

string connStr = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;

SqlCommand cmd = new SqlCommand();

SqlConnection con;

protected void Page_Load(object sender, EventArgs e)

{

if (!Page.IsPostBack)

{

BindGrid();

}

}

private void BindGrid()

{

con = new SqlConnection(connStr);

cmd.Connection = con;

cmd.CommandText = "Select * from student";

con.Open();

GridView1.DataSource = cmd.ExecuteReader();

GridView1.DataBind();

con.Close();

}

protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)

{

if (e.Row.RowType == DataControlRowType.DataRow)

{

LinkButton l = (LinkButton)e.Row.FindControl("LinkButton1");

l.Attributes.Add("onclick", "javascript:return " + "confirm('Are you sure you want to delete this record:: " + DataBinder.Eval(e.Row.DataItem, "sid") + "')");

}

}

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)

{

string sid = (string)GridView1.DataKeys[e.RowIndex].Value;

SqlConnection con = new SqlConnection(connStr);

cmd.Connection = con;

cmd.CommandText = "DELETE FROM student WHERE sid='" + sid + "'";

con.Open();

cmd.ExecuteNonQuery();

con.Close();

BindGrid();

}

}