Asp.net programming we consider all important topic for knowledge about controls,web Services, JSON, Ajax, database, and interview related Question. In this Asp.net and sql server tutorial blog we give many examples of jquery as like How Play YouTube Video in Your Asp.net Website by URL, How to Play YouTube Videos in Asp.net by using Jquery , Jquery Change div background on mouseover in asp.net , JQuery UI Datepicker (Calendar) etc.

Sunday, October 19, 2014

Export Data from Gridview to Excel in Asp.net using C#:

How to Export Data from Gridview to Excel in Asp.net:



There is Many Other Posts Related to this:-

Export Gridview Data to Excel in ASP.NET:


<%@ Page Language="C#" AutoEventWireup="true" CodeFile="excel.aspx.cs" Inherits="excel" %>
 <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <div id="div" runat="server">
      <asp:Button ID="btnExport" runat="server" Text="Export" OnClick="btnExport_Click" />
        <div runat="server" id="divexport">
            <h1 style="color: Green">
                Export to excel sample...</h1>
            <asp:GridView ID="gv" runat="server" CellPadding="4" ForeColor="#333333" GridLines="None">
                <AlternatingRowStyle BackColor="White" />
                <FooterStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                <HeaderStyle BackColor="#990000" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="#FFCC66" ForeColor="#333333" HorizontalAlign="Center" />
                <RowStyle BackColor="#FFFBD6" ForeColor="#333333" />
                <SelectedRowStyle BackColor="#FFCC66" Font-Bold="True" ForeColor="Navy" />
               
            </asp:GridView>
        </div>
    </div>
    </form>
</body>
</html>

C# :Export Gridview into Excel in ASP.NET

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
public partial class excel : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            bindGrid();
        }
    }

    public void bindGrid()
    {
        DataTable dt = new DataTable();
        dt.Columns.Add("SNO");
        dt.Columns.Add("Department");
        dt.Columns.Add("EmpName");
        dt.Columns.Add("EmpNo");
        dt.Columns.Add("Location");
        dt.Columns.Add("Designation");
        for (int i = 0; i < 10; i++)
        {
            DataRow dr = dt.NewRow();
            dr["SNO"] = i;
            dr["Department"] = "Department-" + i;
            dr["EmpName"] = "EmpName-" + i;
            dr["EmpNo"] = "EmpNo-" + i;
            dr["Location"] = "Location-" + i;
            dr["Designation"] = "Designation-" + i;
            dt.Rows.Add(dr);
            dt.AcceptChanges();
        }
        gv.DataSource = dt;
        gv.DataBind();
    }

    protected void btnExport_Click(object sender, EventArgs e)
    {
        Response.Clear();
        Response.AddHeader("content-disposition", "attachment;filename=File.xls");
        Response.Charset = "";
        Response.Cache.SetCacheability(HttpCacheability.NoCache);
        Response.ContentType = "application/vnd.xls";
        System.IO.StringWriter stringWrite = new System.IO.StringWriter();
        System.Web.UI.HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
        divexport.RenderControl(htmlWrite);
        Response.Write(stringWrite.ToString());
        Response.End();
    }     

    public override void VerifyRenderingInServerForm(Control control)
    {
    }
}


No comments:

Post a Comment