Wrox Programmer Forums
Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 2.0 > ASP.NET 2.0 Professional
| Search | Today's Posts | Mark Forums Read
ASP.NET 2.0 Professional If you are an experienced ASP.NET programmer, this is the forum for your 2.0 questions. Please also see the Visual Web Developer 2005 forum.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 2.0 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old August 6th, 2007, 02:47 AM
Authorized User
 
Join Date: Sep 2006
Location: , , .
Posts: 23
Thanks: 0
Thanked 0 Times in 0 Posts
Default Can we directly export dataset to EXCEL



Hi,

What i generally do to export data to excel
1. populate a dataset
2. bind it to datagrid/Repeater/Gridview/Datatable
3. Export it to Excel

Is there any other way to export directly from a dataset so that i can rearrange the columns to display.

Thanks in advance

  #2 (permalink)  
Old August 6th, 2007, 07:49 AM
Friend of Wrox
 
Join Date: Aug 2006
Location: Amman, , Jordan.
Posts: 109
Thanks: 0
Thanked 0 Times in 0 Posts
Default

well I had this issue for some time now and I can't find a way to do it, but as for you problem y don't u rearrange the dataset before binding the data to the gridview and then export it?



Nothing is impossible. The impossible only takes longer. "Digital Fortress, Dan Brown"


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export data into the xls Sheet Directly without cl Kali Charan Tripathi Reporting Services 0 October 9th, 2008 06:40 AM
DataSet export to .csv file snufse1 ASP.NET 2.0 Basics 3 September 22nd, 2008 07:22 AM
Export dataset to Excel zaghmout ASP.NET 2.0 Professional 1 June 21st, 2007 04:10 AM
export dataset into existng ms access data drachx General .NET 0 October 13th, 2005 08:50 PM
How to Export data, of a DataSet to an Excel File swadhinm ASP.NET 1.x and 2.0 Application Design 5 May 25th, 2005 11:11 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.