Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How can i export datatable to excel

Software Development


Reply
 
Thread Tools Search this Thread
  #1  
Old 30-01-2009
Member
 
Join Date: Dec 2007
Posts: 38
How can i export datatable to excel
  

Hi,
I want to know that how can i export the datatable to ms excel?
Is there any quice way to do this? or delimited the file?
Where is the appropriate Microsoft monitored group to ask about
writing reports in SQL Reporting services or SQL Server
Business Intelligence Development Studio or whatever it's called?

Reply With Quote
  #2  
Old 30-01-2009
Member
 
Join Date: May 2008
Posts: 115
Re: How can i export datatable to excel

It's going to be slow compared to native VBA code. There are a few ways to
do thiis...the best of which is to query the DataBase
directly from Excel.
If you check out www.aspnetPRO.com (October 2003) they discuss Exporting to
Excel in depth, albiet primarily from the perspective of ASP.NET.
Reply With Quote
  #3  
Old 30-01-2009
Member
 
Join Date: Dec 2007
Posts: 38
Re: How can i export datatable to excel

I should have made this clearer. I mean a datatable in VB.net.
dim mydt as new datatable
myodbcdataadapter.fill(mydt)
do some processing then export to excel.
Reply With Quote
  #4  
Old 30-01-2009
Member
 
Join Date: May 2008
Posts: 115
Re: How can i export datatable to excel

If we want to use the System.Web.UI.WebControls in the console or windows
form VB.NET application. We need to add a reference to System.Web assembly.
To reference this assembly in VB.NET 2008, we open the Solution Explorer
Window, right click our project and choose Add Reference option. Then, the
Add Reference dialog pops up. In the .NET tab, we find and select the
System.Web, and click the OK button. Afterwards, we can use the
System.Web.UI.WebControls.DataGrid.
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags: ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How can i export datatable to excel"
Thread Thread Starter Forum Replies Last Post
How to export ical to excel Xmen Windows Software 5 02-09-2010 07:41 AM
php export to excel Derwin Software Development 3 25-08-2009 06:25 PM
Export OLE object to Excel? Kelsey Windows Software 3 31-03-2009 09:29 PM
Exporting datatable to excel with ADO.net Sanket07 Software Development 2 03-02-2009 05:52 PM
Export to Excel nehal_serpa Microsoft Project 6 11-12-2008 12:44 AM


All times are GMT +5.5. The time now is 09:59 AM.