using LINQ to set state and automatically populated city in mvc

Question

1.00/5 (1 vote)

See more:

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 ->Primarykey,statename

For city Cityid->primary key, City-name , StateId->foreign key

What procedure i want to write in controller and partialviews

Posted 12-Aug-14 19:28pm

JOTHI KUMAR Member 10918227

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jameel VM · Answer 1 · 2014-08-12T19:49:00

Solution 1

Try this link..
Cascading Dropdown List With MVC, LINQ to SQL and AJAX[^]
http://www.c-sharpcorner.com/UploadFile/4d9083/creating-simple-cascading-dropdownlist-in-mvc-4-using-razor/[^]

Hope this helps

Posted 12-Aug-14 19:49pm

Jameel VM

Comments

JOTHI KUMAR Member 10918227 13-Aug-14 1:58am

Here i make LINQ connection . state and city table are in static in database. so i need to connect database tables. i want to write code in controller and views can explain me in code.how to write LINQ to populate this state and city

Jameel VM 13-Aug-14 2:07am

the link i have shared has almost all the requirement you need. Please atleast try to do it.

JOTHI KUMAR Member 10918227 13-Aug-14 2:40am

sorry to say to you jameel i already tried this link Here i just need LINQ query

Jameel VM 13-Aug-14 2:41am

what problem you are facing?

JOTHI KUMAR Member 10918227 13-Aug-14 2:44am

Here i gave all think but i need LINQ query and how to write Code in controller and partial views to populate state and city

Jameel VM 13-Aug-14 2:48am

where you are stuck..linq query or MVC side? please first start with Linq first and then complete view part

JOTHI KUMAR Member 10918227 13-Aug-14 3:06am

i'm totally stuck in Linq query in controller i want to write can you help me please

JOTHI KUMAR Member 10918227 13-Aug-14 3:11am

Here i used this function for populate value to id in database tables
var branchList = (from s in db.Branches
join co in db.Country on s.Country_Id equals co.Country_Id
join st in db.State on s.State_Id equals st.State_Id
join ct in db.City on s.City_Id equals ct.City_Id
select new
{
s.Branch_Id,
s.Branch_Name,
s.Country_Id,
s.State_Id,
s.City_Id,
co.Country_Name,
st.State_Name,
ct.City_Name
});

//Binding the db linq values

List<viewbranch> brnchList = new List<viewbranch>();
foreach (var m in branchList)
{
ViewBranch blist = new ViewBranch();
blist.Branch_Id = m.Branch_Id;
blist.Branch_Name = m.Branch_Name;
blist.Country_Id = m.Country_Id;
blist.Country_Name = m.Country_Name;
blist.State_Id = m.State_Id;
blist.State_Name = m.State_Name;
blist.City_Id = m.City_Id;
blist.City_Name = m.City_Name;
brnchList.Add(blist);
}

Here now i want populate state and city automatically load

JOTHI KUMAR Member 10918227 13-Aug-14 3:39am

what hapn???? jameel

Jameel VM 13-Aug-14 4:05am

first of all you no need to add to list again. just call toList() method.select new
{
s.Branch_Id,
s.Branch_Name,
s.Country_Id,
s.State_Id,
s.City_Id,
co.Country_Name,
st.State_Name,
ct.City_Name
}).ToList();

Jameel VM 13-Aug-14 4:06am

where is your controller code and view code you had tried?

JOTHI KUMAR Member 10918227 13-Aug-14 4:24am

i wont tried can you give me some ideas for this

Jameel VM 13-Aug-14 4:56am

please refer my blog ..http://fromjami.wordpress.com/2013/09/17/loading-dropdownlist-in-asp-net-mvc/ .. So you will get an idea first

JOTHI KUMAR Member 10918227 13-Aug-14 5:53am

here your blog you gave static but i want to take from database table

Yogesh Kumar Tyagi · Answer 2 · 2014-08-13T02:15:00

Solution 3

http://www.c-sharpcorner.com/UploadFile/4d9083/creating-simple-cascading-dropdownlist-in-mvc-4-using-razor/[^]

http://www.binaryintellect.net/articles/b58fde6b-415e-454d-985b-d5dc4ad2fca8.aspx[^]

http://jnye.co/Posts/12/creating-cascading-dropdownlists-using-mvc-4-and-jquery[^]

see it

Posted 13-Aug-14 2:15am

Yogesh Kumar Tyagi