2 textbox fill on dropdownselection in MVC

Question

1.00/5 (1 vote)

See more:

i want to fill two textboxes from database on the seletion of dropdownlist.

What I have tried:

can anyone give me demo on this question. i am stucking here.i tried my best.but not getting output.

Posted 25-May-16 0:59am

Member 12385326

Updated 25-May-16 21:57pm

Add a Solution

Comments

Karthik_Mahalingam 25-May-16 7:42am

try this
Asp.net MVC - call database on dropdown value change - Stack Overflow[^]
and come back if you are facing any issue.

Karthik_Mahalingam 26-May-16 1:32am

where is the code for getting value from database ?

prakash00060 25-May-16 7:42am

Please clear your need.

1 solution

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)

Karthik_Mahalingam · Accepted Answer · 2016-05-25T21:57:00

Solution 1

try this

C#

public ActionResult GetValuesFromDatabase(string inputId)
      {
          int inputid = Convert.ToInt32(inputId);
          using (AccountDBEntities2 acc = new AccountDBEntities2())
          {
              var item = acc.tbl_CustomerCreation.FirstOrDefault(k => k.Account_No == inputid);
              if (item != null) return Json(item);
              else
                  return null;
          }
      }

in the ajax success method:

JavaScript

      success: function(response) {
//assign values to your textboxes.
$("#CustomerName").val(response.Customer_Name);
$("#Address").val(response.Billing_Address);
}

Posted 25-May-16 21:57pm

Karthik_Mahalingam

Comments

Member 12385326 26-May-16 4:12am

@karthik still it is not working :(

Karthik_Mahalingam 26-May-16 4:18am

ok.
Follow these steps
keep a break point in this method (GetValuesFromDatabase) and execute line by line and check whether you are getting the item

Karthik_Mahalingam 26-May-16 5:27am

try this
int inputid = Convert.ToInt32(inputId);
AccountDBEntities2 acc = new AccountDBEntities2();
var item = acc.tbl_CustomerCreation.FirstOrDefault(k => k.Account_No == inputid);
if (item != null) return Json(item);
else
return null;

Karthik_Mahalingam 26-May-16 5:44am

try this
var _inputID = $("#SalesOrderAccNoDropDown1").val();
var link = '@Url.Action("GetValuesFromDatabase", "Quotation")'
var args = {inputID: _inputID};

$.ajax({
type: "POST",
url: link,
data: args,
dataType: "json",
success: function (result) {
alert(response.Biliing_Address)
},
error: function (httpRequest, textStatus, errorThrown) {
alert("Error: " + textStatus + " " + errorThrown + " " + httpRequest);
}
});

Karthik_Mahalingam 26-May-16 5:51am

ok fine. you use your old code only..
are you getting the inputID in Actionmethod ?

Karthik_Mahalingam 26-May-16 5:45am

item is null means, that value is not in the database
are you getting the correct value in the
int inputid = Convert.ToInt32(inputId); ??

Karthik_Mahalingam 26-May-16 5:53am

2 questions:
are you getting the dropdownvalue in the controller ?
how many items are ther in the db table and does the id passed from ajax matched with anyone item in the db table ?

Karthik_Mahalingam 26-May-16 7:14am

Check the table of the id 2 is present

Karthik_Mahalingam 26-May-16 7:19am

Check the count in tbl_customercreation object

Member 12385326 26-May-16 7:25am

it is showing count=0 :(

Karthik_Mahalingam 26-May-16 7:26am

Fix this first

Karthik_Mahalingam 26-May-16 7:39am

oh good progress,
make sure the property name is correct in javascript

Karthik_Mahalingam 26-May-16 7:47am

hardcode the value in both the textbox and check if it works actually.
$("#CustomerName").val('my cust');
$("#Address").val('my add');

Karthik_Mahalingam 26-May-16 7:49am

ok good.
if your issue is resolved, please close this post by clicking "accept answer" button.

Member 12385326 26-May-16 7:51am

yes sure

Karthik_Mahalingam 26-May-16 7:52am

Thank you :)

Member 12385326 26-May-16 4:20am

okk..i'll let u know