C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...
New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




need country code+ state code +city code


Posted Date: 05 Jun 2007      Total Responses: 2
Posted By: kunal       Member Level: Silver     Points: 2




dear sir/madam
i have 3 dropdown list ..
first is country ,second is state and last on is city
when i click country ,state dropdown list is filled related to country and fill city ,corresponding state
i want country code and state code and city code

plss help me???
sanjay



Responses
Author: Cema Indumathy V    05 Jun 2007Member Level: DiamondRating:     Points: 2
da = new SqlDataAdapter("select * from Country",con) da.Fill(ds) ddlCountry.Datasource = ds.Tables(0) ddlCountry.DisplayMember = "countryname" ddlCountry.DisplayValue = "countryid" da = new SqlDataAdapter("select * from state where countryid = " + ddlCountry.SelectedValue,con) da.Fill(ds) ddlState.Datasource = ds.Tables(0) ddlState.DisplayMember = "statename" ddlState.DisplayValue = "stateid" da = new SqlDataAdapter("select * from city where stateid = " + ddlState.SelectedValue,con) da.Fill(ds) ddlCity.Datasource = ds.Tables(0) ddlCity.DisplayMember = "Cityname" ddlCity.DisplayValue = "C


Author: Cema Indumathy V    05 Jun 2007Member Level: DiamondRating:     Points: 2
da = new SqlDataAdapter("select * from Country",con) da.Fill(ds) ddlCountry.Datasource = ds.Tables(0) ddlCountry.DisplayMember = "countryname" ddlCountry.DisplayValue = "countryid" da = new SqlDataAdapter("select * from state where countryid = " + ddlCountry.SelectedValue,con) da.Fill(ds) ddlState.Datasource = ds.Tables(0) ddlState.DisplayMember = "statename" ddlState.DisplayValue = "stateid" da = new SqlDataAdapter("select * from city where stateid = " + ddlState.SelectedValue,con) da.Fill(ds) ddlCity.Datasource = ds.Tables(0) ddlCity.DisplayMember = "Cityname" ddlCity.DisplayValue = "Cityid"


Post Reply
You must Sign In to post a response.
Next : Strugling for five days to solve this error..can anyone help me???
Previous : urgent...
Return to Discussion Forum
Post New Message
Category: .NET

Related Messages


dotNet Slackers   BizTalk Adaptors    Web Design

email fax service

Contact Us    Privacy Policy    Terms Of Use