Project help needed ....


I will get the column information ONE BY ONE like this:

Country                      Product

USA                            Shirt
USA                            Pant

UK                              Skirt
UK                             Saree

Now i want to display the data like this:

Country                      Product

USA                             Shirt
UK                               Skirt

I may get the data like this:

Country                        Sate                           Product

USA                              IL                                Shirt
USA                              IL                                Pant
USA                              WA                             Skirt  
USA                              WA                             Saree

UK                                NJ                                 Shirt
UK                                NJ                                 Pant
UK                                GA                                Skirt  
UK                                GA                                Saree

Then i need to diaplay data like this:

Country                          State                      Product

USA                                 IL                            Shirt
                                        WA                         Skirt

UK                                   NJ                            Shirt
                                        GA                           Skirt

This will go on for N-Dimensions like this:

Country                           State                        City                          Product

USA                                IL                            Chicago                       Pant
                                                                      Bloomington                Shirt
                                      NJ                            Jersey City                  Skirt          
                                                                      Ottava                         Saree

Can you please provide me code to dispaly the data like this ?

Appreciate your time and patience ....

Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

what kind of technology you want to use to create this?
will this be a report or a form?

if it will be a report in e.g. crystal or reporting services, you can simply check the 'remove duplicate values' box, which will result in what you described exactly.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
milani_lucieAuthor Commented:
I am using just VC#.NET 2005 to create a table and do manipulations.

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.