how to select state and automatically populated city using l

Question

hi to all Here i have dropdown for state and city using model. but now i want populate city as per state selection.Can anybody help me.Here im using linq so kindly help me Here im using database table Description:- For state Stateid ->Primarykeystatename For city Cityid->primary key City-name  StateId->foreign key Can anybody help me how to populate city as per state name using LINQ

Sumit Jolly · Answer

can you please paste code so i get sense of what you're upto now?

jothi kumar · Answer

i wrote only populate city and state name from database table. but how to populate that

Sumit Jolly · Answer

do you've any code written that i can refer and alter

jothi kumar · Answer

u just gave only using asp.net but i want in mvc and one important using LINQ .here i done dropdown all think i want to just do only populate city as per state

Sumit Jolly · Answer

hi Jothi this is common problem to solve there is good blog and http://www.c-sharpcorner.com/uploadfile/rohatash/dropdownlist-with-country-state-and-city-in-asp-net/ once you do that using regular sql then we can convert using LINQ