Solved

VB.Net: ListView to Excel

Posted on 2012-04-09
5
509 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 5

Assisted Solution

by:rtay
rtay earned 200 total points
ID: 37823905
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
ID: 37823999
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
ID: 37824039
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
ID: 37832975
0
 

Author Comment

by:baabaa_nl
ID: 37846365
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

623 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