Hello OP ,
I have modified your question and as per this below is the solution.
Let say you have two table like this
Country {CountryId, CountryName }
State {stateid,stateName,countryid}
Create below procedure for Coutry drop down box
CREATE PROCEDURE FindAllCountry
BEGIN
SELECT CountryId ,CountryName FROM Country
END
then execute this proc and populate country drop down box and display countryname and also tag countryid with each country name so that when user does selection then will get country id from tag.
Again create one procedure to populate state drop down box
CREATE PROCEDURE FindState(@CountryId BIGINT)
BEGIN
SELECT stateid,stateName FROM State where countryid=@CountryId
END
now execute this proc and populate state drop down box .
Display state name and tag state id
Hope this helps . If yes then accept and vote this answer or revert back with your queries
--RDBurmon