Get States list of states according to selected country [closed]

Question

I want to retrieve names of all the states list of a particular country which is selected from a drop down menu.

I know how to retrieve the list of all countries via apple code but now i want the list of all the states.

Is there any code db or API available for that?

Answer 1

You can download this sqlite file. This is a database of countries with their respective states. you can re - create a query every time the user selects a country.

NSString *queryString = [NSString stringWithFormat:@"select zone_id , name from
                       zone where country_id = %d", countryID];