-
Jan 13th, 2009, 03:03 AM
#1
Thread Starter
Addicted Member
[RESOLVED] Best way to repopulate ListView in vb.Net
(Migrating from vb6 to vbNet) I have an Excel file I need to leave undisturbed. I can loop through it and populate a ListView with columns during form load. After that I want to repopulate the ListView, changing column headers and presenting the same data in a different order or with some columns absent. If I created my Excel application As Object when loading the form it is obviously no longer available from a new button as the button is Private. What is the convention for doing this? Does ADO.NET work with Excel? I want to keep the data source invisible (.visible = False) yet manipulate it for the ListView. I could create a text fiile from the Excel and loop through that in each button code. That seems a poor way to do it. There will be no input from the user, just reading from 22 columns displaying only 3 or 4 of them at a time in ListView. Strategy needed please and maybe one or two code examples from a guru.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|