Html.dropdownlist to query string in url

Question

0.00/5 (No votes)

See more:

Dear Gents,

I have a dropdownlist which will pass the data to the query string and its working fine. I have another dropdownlist that i want to pass the value to the query string in url along with the previous dropdown, how can i do that in asp.net mvc

your help is much appreciated and save my hours.

Regards

Posted 19-Feb-13 10:03am

Ahamed Azeem

Add a Solution

Comments

ZurdoDev 19-Feb-13 16:09pm

If you have code that does one dropdownlist into the query string what's the issue getting the 2nd one to be there as well?

Zoltán Zörgő 19-Feb-13 16:12pm

It looks quite simple, so please paste here the relevant portion of the view.

Ahamed Azeem 19-Feb-13 16:35pm

Dear Ryan,

That is the issue, when I select a dropdown, the url query string is replaced by the other value,

for ex
http://localhost:7919/Contract/Create?OccupationId=f73536b5-f18c-470c-b921-f542e5b39962

or

http://localhost:7919/Contract/Create?NationalityId=fb92cf56-716b-414a-99f6-c97ad440a8db

Either any one of the above value is coming not both. I want the url to keep the value and append the other one

regards

Ahamed Azeem 19-Feb-13 16:15pm

Dear Ryan,

That is the issue, when I select a dropdown, the url query string is replaced by the other value,

for ex
http://localhost:7919/Contract/Create?OccupationId=f73536b5-f18c-470c-b921-f542e5b39962

or

http://localhost:7919/Contract/Create?NationalityId=fb92cf56-716b-414a-99f6-c97ad440a8db

Either any one of the above value is coming not both. I want the url to keep the value and append the other one

regards

[no name] 19-Feb-13 16:44pm

How can anyone tell what it is that you are doing wrong unless you post the code?

Ahamed Azeem 19-Feb-13 16:47pm

@Html.DropDownList("NationalityId", ViewBag.NationalityId as SelectList, String.Empty, new { onchange = "location.href='/Contract/Create?NationalityId='+this.options[this.selectedIndex].value" })

@Html.DropDownList("OccupationId", ViewBag.OccupationId as SelectList, String.Empty, new { onchange = "location.href='/Contract/Create?OccupationId='+this.options[this.selectedIndex].value" })

This is the code for two dropdown values

regards

Zoltán Zörgő 19-Feb-13 16:51pm

If you have onchange on both, you can not change both at once. Is the action you call different from the view this code is in?

2 solutions

Solution 2

[removed, duplicated by the system, but I can't delete it]

Posted 19-Feb-13 11:00am

Zoltán Zörgő

Updated 19-Feb-13 11:15am

v3

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)

**Zoltán Zörgő** · Accepted Answer · 2013-02-19T10:46:00

Solution 1

HTML

<script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
<script>
 $(function() {
     var collectParams = function(){
		var params = { OccupationId:$("#Occupation").val(), NationalityId:$("#Nationality").val() };
		if(params.OccupationId && params.NationalityId)
		{
			location.href=@Html.Action("Create","Contact") + "?" + jQuery.param(params)
		}
	 };
	 
	 $("#Nationality").change(collectParams);
	 $("#Occupation").change(collectParams);
    });
</script>
@Html.DropDownList("NationalityId", ViewBag.NationalityId as SelectList, String.Empty, new { id="Nationality" })
@Html.DropDownList("OccupationId", ViewBag.OccupationId as SelectList, String.Empty, new { id="Occupation" })

OnChange is called for both dropdowns, but it is triggering relocation only if both are specified.

Posted 19-Feb-13 10:46am

Zoltán Zörgő

Updated 19-Feb-13 11:25am

v3

Comments

Ahamed Azeem 19-Feb-13 16:51pm

Dear Zoltan,

I have posted my view details in the previous comment, pls check and suggest

Zoltán Zörgő 19-Feb-13 16:53pm

I would not use onchange, since than you can change only one of them. Put this logic on javascript side as suggested. Do you want to refresh the same view with different parameters or is the /Contract/Create an other one?

Ahamed Azeem 19-Feb-13 17:01pm

actually i am brining another data from the database using nationality id and occupation id, that data will automatically get filled in the textbox once both of these values selected

Zoltán Zörgő 19-Feb-13 17:25pm

See update

Ahamed Azeem 24-Feb-13 1:11am

It shows below exception

"The controller for path '/Contract/Create' was not found or does not implement IController."}

Ahamed Azeem 24-Feb-13 1:19am

Sorted out, but now it shows stack over flow exception in the script

Zoltán Zörgő 24-Feb-13 1:30am

Should work. Paste following code in a stand-alone html file and open it in the browser:


<script src="http://code.jquery.com/jquery-1.9.1.min.js"></script>
<script>
 $(function() {
     var collectParams = function(){
		var params = { OccupationId:$("#Occupation").val(), NationalityId:$("#Nationality").val() };
		if(params.OccupationId && params.NationalityId)
		{
			location.search=jQuery.param(params)
		}
	 };
	 
	 $("#Nationality").change(collectParams);
	 $("#Occupation").change(collectParams);
    });
</script>
<select id="Nationality"><option value="">?</option><option value="1">1</option><option value="2">2</option></select>
<select id="Occupation"><option value="">?</option><option value="2">2</option></select>

You will see, that it is jumping only if both are specified. If you get such exceptions, you have some other bug, or you have used my code in the wrong way.

Ahamed Azeem 24-Feb-13 1:44am

its working in a standalone but when i put it inside view its showing error and the page is not loaded

Zoltán Zörgő 24-Feb-13 3:45am

What error? If your dropdown code snippets worked, mines should work also in that context. My dropdowns were only for demonstration. The javascript code is the interesting part.

Ahamed Azeem 24-Feb-13 3:54am

Thanks a lot its worked, i removed action link in location and passed a constant string

Zoltán Zörgő 24-Feb-13 5:58am

Good. But there is still a problem on your side. Html.Action is the way to create action links.

Ahamed Azeem 24-Feb-13 6:05am

Yes you are right, but i am not creating the action link, am just append the query strings to the existing link