Click here to Skip to main content
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 18: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 Maciej Los 424
1 ridoy 410
2 DamithSL 240
3 OriginalGriff 179
4 Suvendu Shekhar Giri 150
0 OriginalGriff 8,033
1 DamithSL 6,179
2 Sergey Alexandrovich Kryukov 5,538
3 Maciej Los 5,508
4 Kornfeld Eliyahu Peter 4,539

Advertise | Privacy | Mobile
Web01 | 2.8.141223.1 | Last Updated 8 Jan 2013
Copyright © CodeProject, 1999-2014
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