Sir,
I showed data in GridView using C#. I want export it in Excel. Please help me how to do this.
below code is used to show gridview.
and also suggest how to enable sorting and delete feature in grid.

protected void Page_Load(object sender, EventArgs e)
{
Label1.Text = Session["sname"].ToString();
SqlConnection con = new SqlConnection("Server=SDCHO\\SQLEXPRESS;Database=LoginPage;Trusted_Connection=true");
con.Open();
SqlCommand CMD = new SqlCommand("select * from LeaveDataTable WHERE Lid=@CHK_ID2 AND Lpass=@CHK_PA2", con);
CMD.Parameters.AddWithValue("@CHK_ID2", Session["sid"]);
CMD.Parameters.AddWithValue("@CHK_PA2", Session["spass"]);
SqlDataReader reader = CMD.ExecuteReader();
GridView1.DataSource = reader;
GridView1.DataBind();
con.Close();
}