Retrive the names in the country,state,cites,state,cites,Country,state,cites by passing record id

create table RecordTable
(
rid int identity primary key,
Name nvarchar(250)
)

create table Country
(
ContryId int identity primary key,
Name nvarchar(250),
rid int
)

create table State
(
stateId int identity primary key,
Name nvarchar(250),
ContryId int
)

create table City
(
cityid int identity primary key,
Name nvarchar(250),
stateId int
)

Select b.Name from RecordTable a,Country b where a.rid=b.rid    -- Country
union all
Select a.Name from State a,Country b where a.ContryId=b.ContryId  -- State
union all
Select a.Name from City a,State b where a.stateId=b.stateId  --City

Select * from City 
inner join state on state.cityid = city.id
inner join country on country.stateid = state.id
order by country.name,state.name,city.name

Protected void BindCountry()
{
            DataSet dsCtry= //get data from database and pass record id as input parameter.
            ddlCtry.DataSource=dsCtry;
            ddlCtry.DataTextField="CountryName";
            ddlCtry.DataValueField="CountryId";
            ddlCtry.DataBind();
}

Protected void ddlCtry_OnSelectedIndexChanged(object sender, EventArgs e)
{
           DataSet dsState=//pass country id as input parameter and fetch data from database.
           ddlState.DataSource=dsState;
           ddlState.DataTextField="StateName";
           ddlState.DataValueField="StateId";
           ddlState.DataBind();
}

 Dataset.Select( filter string).