Click here to Skip to main content
11,630,646 members (77,939 online)
Click here to Skip to main content

Import and Export Data from GridView

, 16 Nov 2007 CPOL 47.2K 1.4K 26
Rate this:
Please Sign up or sign in to vote.
Import and Export Data from GridView


I am not a good article writer. I am glad to have this opportunity to present this article to you. This article will help you understand how to Import and Export the GridView data into Microsoft Excel format.

Using the Code

Use this code in your codebehind file:

// Code Behind

using System.Data.OleDb;
using System.IO;

public partial class Forms_WebImportExport : System.Web.UI.Page
    public void fillGrid()
        DataSet ds = new DataSet();
        GridView1.DataSource = ds;
    protected void Page_Load(object sender, EventArgs e)
        if (!IsPostBack)
    protected void btImport_Click(object sender, EventArgs e)
        string conn = ("Provider=Microsoft.Jet.OLEDB.4.0;" + 
			("Data Source=C:\\path\\test.xls;" + 
                       	// or use instead of Excel 8.0 - Excel 5.0
			"Extended Properties=\"Excel 8.0;\"")); 
			 string SSQL = "SELECT name , dept, salary from [sheet1$]";

        // here use oleDataReader
        OleDbDataAdapter oleDA = new OleDbDataAdapter(SSQL, conn); 
        DataSet ds = new DataSet();
        //oleDA.TableMappings.Add("Table","ExcelTest"); // Require
        GridView1.DataSource = ds.Tables[0].DefaultView; // or [ ds ]
    protected void btExport_Click(object sender, EventArgs e)
        ExportGridToExcel(GridView1, "myExcel");
    public void ExportGridToExcel(GridView grdGridView, string fileName)
        Response.Charset = "";
        Response.ContentType = "application/vnd.xls";
        StringWriter stringWrite = new StringWriter();
        HtmlTextWriter htmlWrite = new HtmlTextWriter(stringWrite);
    public override void VerifyRenderingInServerForm(Control control)
        /* method must be implemented when using RenderControl */


<%@ Page Language="C#" AutoEventWireup="true" 
    CodeFile="WebImportExport.aspx.cs" Inherits="Forms_WebImportExport" %>

<html xmlns="" >
<head runat="server">
<title>Untitled Page</title>
<form id="form1" runat="server">
<asp:Button ID="btImport" runat="server" OnClick="btImport_Click" Text="Import" /> 
<asp:Button ID="btExport" runat="server" OnClick="btExport_Click" Text="Export" /><br />
<br />
<asp:GridView ID="GridView1" runat="server" BackColor="White" BorderColor="#E7E7FF"
BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Horizontal">
<FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" />
<RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" />
<SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />
<PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />
<HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" />
<AlternatingRowStyle BackColor="#F7F7F7" />
<br />

Points of Interest

I hope I tried to explain well. If you like this code, please vote for this article. Please!
Thank you.


  • 17th November, 2007: Initial post


This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


About the Author

Software Developer (Senior)
India India
No Biography provided

You may also be interested in...

Comments and Discussions

QuestionA cleaner way Pin
CikaPero19-Jul-11 21:57
memberCikaPero19-Jul-11 21:57 
Generalfailed to map path Pin
orked mohamed27-Mar-09 22:42
memberorked mohamed27-Mar-09 22:42 
GeneralExport girdview with paging Pin
gargvijay18-Mar-09 20:48
membergargvijay18-Mar-09 20:48 
Generalproblem about the excel file's head Pin
shi_ly10-Dec-08 22:45
membershi_ly10-Dec-08 22:45 
GeneralCould not find installable ISAM Pin
cky4251-Jul-08 17:01
membercky4251-Jul-08 17:01 
Generalthanx Pin 8:34 8:34 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web04 | 2.8.150723.1 | Last Updated 17 Nov 2007
Article Copyright 2007 by KennyPatel
Everything else Copyright © CodeProject, 1999-2015
Layout: fixed | fluid