i have table having three columns state,city and address

a state have multiple cities and there are many records for one city.

i fetch all the data from database by datareader. or when i get city i get all records for that city in dataset.

my main trouble is how to display data in required form. i want to display data in following form:

State1 (one time)

City1 (one time)

Address1

Address2

Address3

City 2

Address1

Address2

Address3

Please help me.



thanks......

__________________
thanks......