Solved

VB.Net: ListView to Excel

Posted on 2012-04-09
5
485 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

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

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

This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.

733 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