How to delete a record from SQL Server database using ADO.Net in ASP.Net Web Application

    protected void Delete_Click(object sender, EventArgs e)
    {

        String strConnString = System.Configuration.ConfigurationManager.ConnectionStrings["conString"].ConnectionString;
        string strQuery;
        SqlCommand cmd;
        strQuery = "delete from customers where CustomerID=@CustomerID";
        cmd = new SqlCommand(strQuery);
        cmd.Parameters.AddWithValue("@CustomerID", "A234");
        SqlConnection con = new SqlConnection(strConnString);
        cmd.CommandType = CommandType.Text;
        cmd.Connection = con;
        try
        {
            con.Open();
            cmd.ExecuteNonQuery();
            con.Close();
        }
        catch (Exception ex)
        {
            Response.Write(ex.Message);
        }
        finally
        {
            con.Close();
            con.Dispose();
        }
    }