Client side Delete Confirmation in a Gridview

This code use for show a message box when delete button clicked on gridview and when to prevent the accidental deletions.

protected void gv1_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
foreach (DataControlField dcf in gv1.Columns)
{
if (dcf.ToString() == "CommandField")
{
if (((CommandField)dcf).ShowDeleteButton == true)
{
e.Row.Cells[gv1.Columns.IndexOf(dcf)].Attributes
.Add("onclick", "return confirm(\"Are you sure?\")");
}
}
}
}
}

Create msgbox in class (C#)

public static void alert(string msg)
{
string jscript = "";

Page page = HttpContext.Current.Handler as Page;
if (page != null)
{
page.RegisterStartupScript("clientScript", jscript);
}
}

Database connection with MSSQL for data reader

VB 'using mssql express edition Dim strConn As String = " \SQLEXPRESS;database=;Integrated Security=SSPI" Dim conn As New SqlConnection(strConn) Dim cmd As SqlCommand = conn.CreateCommand Dim reader As SqlDataReader cmd.CommandText = "Select * from clients where client_id = '" + iid.ToString() + "'" conn.Open() reader = cmd.ExecuteReader If reader.Read = True Then TextBox1.Text = reader.GetString(1) TextBox2.Text =reader.GetDatetime(2) TextBox3.Text = reader.GetString(3) TextBox4.Text = reader.GetString(4) End If conn.Close() C# string strConn = "\\SQLEXPRESS;database=;Integrated Security=SSPI"; SqlConnection conn = new SqlConnection(strConn); SqlCommand cmd = conn.CreateCommand; SqlDataReader reader; cmd.CommandText = "Select * from clients where client_id = '" + iid.ToString() + "'"; conn.Open(); reader = cmd.ExecuteReader; if (reader.Read == true) { TextBox1.Text = reader.GetString(1); TextBox2.Text = reader.GetDatetime(2); TextBox3.Text = reader.GetString(3); TextBox4.Text = reader.GetString(4); } conn.Close();