Solved

VB.Net: ListView to Excel

Posted on 2012-04-09
5
474 Views
Last Modified: 2012-04-15
Hi Experts,

I need to export the data in a ListView to be exported to an Excel.

Thanks in advance.
0
Comment
Question by:baabaa_nl
  • 2
  • 2
5 Comments
 
LVL 5

Assisted Solution

by:rtay
rtay earned 200 total points
Comment Utility
An easy way would be to create a SSRS report (embeded or not) based on the same query and use the report export function to save to Excell.
0
 

Author Comment

by:baabaa_nl
Comment Utility
Could you please give me a code or the link for the SSRS report.
Thanks in advance.
0
 
LVL 5

Assisted Solution

by:rtay
rtay earned 200 total points
Comment Utility
In Visual Studio, right click on your project in the solution explorer.
Add new item
Repoting
create a test report using the wizard.
Once you create the report, go add a new windows form to your project and from the tool box, under reporting add a Microsoft report viewer to the form.  using the tag in the report viewer item, point to the report you just created.  

Create a link to that new form from your list view form.  

Here is more information on SSRS reports.

http://www.packtpub.com/article/creating-report-with-visual-studio-2008
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 300 total points
Comment Utility
0
 

Author Comment

by:baabaa_nl
Comment Utility
Hi CodeCruiser,

The link you give me is for exporting data to excel from the Dataset.

But I need to export data to excel from a ListView

Thanks in advance.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Well, all of us have seen the multiple EXCEL.EXE's in task manager that won't die even if you call the .close, .dispose methods. Try this method to kill any excels in memory. You can copy the kill function to create a check function and replace the …
I think the Typed DataTable and Typed DataSet are very good options when working with data, but I don't like auto-generated code. First, I create an Abstract Class for my DataTables Common Code.  This class Inherits from DataTable. Also, it can …
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now