SQL Server - how to select each data from table ?

Asked By saranya on 02-May-13 06:05 AM
Hi frndz!

I am doing project in MSSQL 2008 . In my project i have to take each data separately from table and have to show.

For eg there are 2 table:

Area table (In this Area table below are the datas)
1.area
2.street
3.rode

AreaType table(In this AreaType table below are the datas)

1.che
2.bng
3.try

based on area table area type has to show in bulleted list

there is one text area in the screen. In the screen display should be like this:

area
  •    che
  •    bng
street

  •     try
  •     che
rode
  •     bng

so whatever area having their area type have to display in above format. so give the code with detail explanation
Thanks frndz.

vinoth kumar replied to saranya on 16-May-13 05:40 AM
u cannot do that in sql ,mabe in c sharp we can add a list type,and use database to populate the data in the list box