How to delete a record in grid view in asp.NET.

     code in cs file
------------------------
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Data;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
public partial class Default2 : System.Web.UI.Page
{
    SqlConnection x;
    SqlCommand y;
    SqlDataReader z;
    protected void Page_Load(object sender, EventArgs e)
    {
        x = new SqlConnection(@"data source=RAJAT\SQLEXPRESS;initial catalog= master;integrated security=sspi;");
        x.Open();
        if (!IsPostBack)
        {
            fillGrid();
        }

    }
    public void fillGrid()
    {
        if (x.State == ConnectionState.Closed)
        {
            x.Open();
        }
        y = new SqlCommand("select * from prateek", x);
        z = y.ExecuteReader();
        if (z.HasRows == true)
        {
            //GridView1.DataSource = z;
            //GridView1.DataBind();
                GridView2.DataSource = z;
                GridView2.DataBind();
        }
       
        else
        {
            Response.Write("no record");
        }
        x.Close();
    }
 
    protected void DeleteRow(object sender, GridViewDeleteEventArgs e)
    {
        Label id = GridView2.Rows[e.RowIndex].FindControl("lblID") as Label;
        y = new SqlCommand("Delete from prateek where id= '" + id.Text + "'", x);
        if (x.State == ConnectionState.Closed)
        {
            x.Open();
        }
        y.ExecuteNonQuery();
        x.Close();
        fillGrid();
    }
}


_______________________________________________________________________________________________________


code in aspx file :-

---------------------------------------------------
    <div>
   
        <br />
        <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="false" OnRowDeleting="DeleteRow">
        <Columns>
        <asp:TemplateField>
        <HeaderTemplate>ID</HeaderTemplate>
        <ItemTemplate>
            <asp:Label ID="lblID" runat="server" text='<%#Bind("id")%>'></asp:Label>
        </ItemTemplate>
        </asp:TemplateField>

        <asp:TemplateField>
        <HeaderTemplate>Name</HeaderTemplate>
        <ItemTemplate>
            <asp:Label ID="lblname"  runat="server" text='<%#Bind("name")%>'></asp:Label>
        </ItemTemplate>
        </asp:TemplateField>

        <asp:TemplateField>
        <HeaderTemplate>Mobile No.</HeaderTemplate>
        <ItemTemplate>
            <asp:Label ID="lblmobile" runat="server" text='<%#Bind("mobile")%>'></asp:Label>
        </ItemTemplate>
        </asp:TemplateField>
        <asp:TemplateField>
        <HeaderTemplate>Operation</HeaderTemplate>
        <ItemTemplate>
            <asp:Button ID="btnDel" runat="server" Text="DEL"  CommandName="Delete" />
        </ItemTemplate>
        </asp:TemplateField>
        </Columns>
        </asp:GridView>
   
    </div>