Last post Feb 26, 2013 09:17 AM by oned_gk
Feb 26, 2013 08:21 AM|Rickinio|LINK
I want to populate a DropDown list with some Tables inside an SQL Server Database.
Further more the table names are SYS_GEO_GR, SYS_GEO_UK, SYS_GEO_US etc and i want to display them on the DropDown not like this but as Greece, United Kingdom, United States etc.
Can you please assist me on this one.
Thanks in advance for your help!
Feb 26, 2013 08:40 AM|ashkc|LINK
select name from sys.tables will give you the list of the table names
Feb 26, 2013 08:49 AM|rajendraram|LINK
what u mean?
Please use two table
and set foriegn key reference in contry to stat table
the u want get all country. use below query for
select * from country// Get all country
you want state
select * from state//get all states
you want states for selected country
select * from state where countryId="US"
Feb 26, 2013 09:17 AM|oned_gk|LINK