Click here to Skip to main content
11,716,938 members (89,763 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: SQL C#4.0 Excel

i am working on a project where the data i have to use from excel and show in treeview control and populating data very smoothly, like in a country ,there are various states and then city ,i wnna use this concept in my project,?? plzz give some suggestion??
Posted 7-Jan-13 17:10pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Pseudo code (assumes desktop application):
create the excel object
open the excel object
open the worksheet with the data
read the data into a collection (assumes the data is in 3 columns Country, State, City)
iterate through the collection creating treeview nodes and their children based on the parent child relationship.

Your question is not well formed and is too broad to be addressed in a forum message. Do some research on reading excel files and populating treeviews

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 599
1 OriginalGriff 255
2 F-ES Sitecore 210
3 Maciej Los 185
4 Richard MacCutchan 130
0 Sergey Alexandrovich Kryukov 1,144
1 Maciej Los 509
2 OriginalGriff 505
3 Richard MacCutchan 440
4 CHill60 415

Advertise | Privacy | Mobile
Web02 | 2.8.150901.1 | Last Updated 8 Jan 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100