Hello Guys.\ ! Today we'll make a program that how to convert GridView data in Excel Sheet.. so......... just you have to make a GridView from your Toolbox along with a button.. nd just make it very easy code. protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { BindData(); } } //just make a connection with your database which table you want to use in your program..... private void BindData() { string constr = @"Server=kishu-pc;Database=NORTHWIND;uid=sa; Password=pass@word1;"; string query = "SELECT ProductID, ProductName, UnitPrice FROM Products"; SqlDataAdapter da = new SqlDataAdapter(query, constr); DataTable table = new DataTable(); da.Fill(table); GridView1.DataSource = table; GridView1.DataBind(); } public override void VerifyRenderingInServerForm(Control control) { // its simply
