coalinfo.aspx.cs

This is not a very mean things.

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

public partial class CoalInfo : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {

    }
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        int CoalID = (int)this.GridView1.DataKeys[e.RowIndex].Value;
        SqlConnection myConnection = new SqlConnection();
        SqlCommand myCommand = new SqlCommand();

        myConnection.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
        myCommand.Connection = myConnection;
        myCommand.CommandText = "delete from Shop where CoalID=" + CoalID;
        myCommand.CommandType = CommandType.Text;

        try
        {
            myConnection.Open();
            myCommand.ExecuteNonQuery();
            myCommand.Dispose();
        }
        catch (SqlException ex)
        {
            throw new Exception(ex.Message, ex);
        }
        finally
        {
            myConnection.Close();
        }
    }
}