Need fast way to populate treeView
-
I have a need to populate a treeview control with a file containing as much as 500,000 lines of data. The data file contains information that could be saved as an Excel .xls file, or a .csv file, or a straight text file. I have a C# project that reads the data from an excel file and populates my treeview control, but it takes FOREVER for just 25,000 lines. And Excel files have the 65K line limit anyway. Can someone tell me what the fastest methode would be to populate a treeview control with data from a file that could contain as many as a half a million lines or more? Thanks.
-
I have a need to populate a treeview control with a file containing as much as 500,000 lines of data. The data file contains information that could be saved as an Excel .xls file, or a .csv file, or a straight text file. I have a C# project that reads the data from an excel file and populates my treeview control, but it takes FOREVER for just 25,000 lines. And Excel files have the 65K line limit anyway. Can someone tell me what the fastest methode would be to populate a treeview control with data from a file that could contain as many as a half a million lines or more? Thanks.
That would say would be a horrendifying experience to the user loading from a text file considering the largest wait time unless the system had enough powerful horsepowers to process it as if it possessed a magical wand. :rolleyes:
Vasudevan Deepak Kumar Personal Homepage Tech Gossips
-
I have a need to populate a treeview control with a file containing as much as 500,000 lines of data. The data file contains information that could be saved as an Excel .xls file, or a .csv file, or a straight text file. I have a C# project that reads the data from an excel file and populates my treeview control, but it takes FOREVER for just 25,000 lines. And Excel files have the 65K line limit anyway. Can someone tell me what the fastest methode would be to populate a treeview control with data from a file that could contain as many as a half a million lines or more? Thanks.
-
I have a need to populate a treeview control with a file containing as much as 500,000 lines of data. The data file contains information that could be saved as an Excel .xls file, or a .csv file, or a straight text file. I have a C# project that reads the data from an excel file and populates my treeview control, but it takes FOREVER for just 25,000 lines. And Excel files have the 65K line limit anyway. Can someone tell me what the fastest methode would be to populate a treeview control with data from a file that could contain as many as a half a million lines or more? Thanks.
I think your approach is wrong here - populating anything user oriented (except my bank account) with 500,000 somethings is pointless. No user would be able to make sense of that much data.
"It was the day before today.... I remember it like it was yesterday." -Moleman
-
I think your approach is wrong here - populating anything user oriented (except my bank account) with 500,000 somethings is pointless. No user would be able to make sense of that much data.
"It was the day before today.... I remember it like it was yesterday." -Moleman
I agree. The approach is wrong. There are other approaches that work better. I'm betting that someone somewhere has implemented a control that can keep a portion of the file in the visible window while the user scrolls up or down. It may not be the ideal solution, but it definitely is not the worst.
Phil
-
I have a need to populate a treeview control with a file containing as much as 500,000 lines of data. The data file contains information that could be saved as an Excel .xls file, or a .csv file, or a straight text file. I have a C# project that reads the data from an excel file and populates my treeview control, but it takes FOREVER for just 25,000 lines. And Excel files have the 65K line limit anyway. Can someone tell me what the fastest methode would be to populate a treeview control with data from a file that could contain as many as a half a million lines or more? Thanks.