Get Drop down List and bind the textbox values in MVC

Question

How to get textbox values based on the selected dropdown list values in Asp.Net MVC? If there's a solution please let me know it.

Faisal Pathan · Answer

$( "#TEXTBOX-ID" ).val($( this ).find( "option:selected" ).val()); // or else make ajax call to retrive address var client = $( this ).find( "option:selected" ).val(); $.ajax({ type: "GET" , url: "/Controller/Action" , data: { "name" : client }, contentType: 'application/json; charset=utf-8' , success: function (response) { if (response != null ) { $( "#TEXTBOX-ID" ).val(response); } }, error: function (xhr, ajaxOptions, thrownError) { alert( 'Failed to retrieve address.' ); } }); });

Sreekanth Reddy · Answer

Hi @Html.DropDownList("Sortby", new SelectListItem[] { new SelectListItem() { Text = "Newest to Oldest", Value = "0" }, new SelectListItem() { Text = "Oldest to Newest", Value = "1" }}, new { @onchange="BindTextBoxValue(this.value)" }); function BindTextBoxValue(valIs){ $.ajax({ url: "controllername/postactionmethodname", type: "POST", data: { id: valIs }, cache: false, async: true, success: function (data) { $("#txtboxid").val(data.d); } } In your controller : [HttpPost] public string postactionmethodname(string valIs) { //Code to get Address by ID return "Address"; }

Faisal Pathan · Answer

you just need to create one action in controller which accept clinetID or clinet name and return clinet address and from view call ajax method which I send in previous reply.

Sreekanth Reddy · Answer

Hi Sourav, Your View : @Html.DropDownList("Sortby", new SelectListItem[] { new SelectListItem() { Text = "Newest to Oldest", Value = "0" }, new SelectListItem() { Text = "Oldest to Newest", Value = "1" }}, new { @onchange="BindTextBoxValue(this.value)" }); Script in view : function BindTextBoxValue(valIs){ $("#txtboxid").val(valIs); } Mark as answer, If it helps. Thank you.

Faisal Pathan · Answer

you want selected Dropdown value right? and with Jquery or somthing else ?

Sourav Kumar Das · Answer

Hi, I am sending you sample code of it below. In View part: @{ ViewBag.Title = "Create" ; Layout = "~/Views/Shared/_MasterLayout.cshtml" ; } "~/Scripts/jquery-1.10.2.min.js" > "~/Scripts/jquery.validate.min.js" > "~/Scripts/jquery.validate.unobtrusive.min.js" > .Err { font-size: 13px; text-align: right; } .actLink:hover { text-decoration: none; text-underline: none; } .padd0 { padding: 0; } .padd10 { margin-top: 5%; padding: 10px; } class = "col-xs-12 padd0" > @ using (Html.BeginForm()) { @Html.AntiForgeryToken() class = "col-xs-12 padd10" > class = "col-xs-12 col-sm-6" > Client Master - Add class = "col-xs-12 col-sm-6 text-right" > '@Url.Action("ShowClientMaster", "ClientMaster")' > class = "imgBack" src= '@Url.Content("~/Content/Images/back-button.png")' height= "30" width= "30" /> class = "col-xs-12 padd0" > class = "col-xs-12 col-sm-6 col-sm-offset-3" style= "margin-top:2%;" > class = "form-horizontal" > @Html.ValidationSummary( true , "" , new { @ class = "text-danger" }) class = "form-group" > class = "col-md-5" style= "text-align:left" > @Html.LabelFor(model => model.Id, htmlAttributes: new { @ class = "control-label" }) class = "col-md-7" > @Html.EditorFor(model => model.Id, new { htmlAttributes = new { @ class = "form-control" } }) @Html.ValidationMessageFor(model => model.Id, "" , new { @ class = "text-danger" }) class = "form-group" > class = "col-md-5" style= "text-align:left" > @Html.LabelFor(model => model.ClientName, htmlAttributes: new { @ class = "control-label" }) class = "col-md-7" > @Html.DropDownListFor(m => m.ClientName, (IEnumerable )ViewBag.ClientLists, "Select Client Name" , new { @ class = "form-control" }) @Html.ValidationMessageFor(model => model.ClientName, "" , new { @ class = "text-danger" }) class = "form-group" > class = "col-md-5" style= "text-align:left" > @Html.LabelFor(model => model.ClientAddress, htmlAttributes: new { @ class = "control-label" }) class = "col-md-7" > @Html.EditorFor(model => model.ClientAddress, new { htmlAttributes = new { @ class = "form-control" , autocomplete = "off" } }) @Html.ValidationMessageFor(model => model.ClientAddress, "" , new { @ class = "text-danger" }) class = "form-group" > class = "col-md-offset-2 col-md-10 text-right" > "submit" value= "Submit" class = "btn btn-primary" /> "reset" value= "Reset" class = "btn btn-danger" /> class = "col-xs-12" > @ if (TempData[ "Message" ] == "Success" ) { "color:green;" > Client Master Details Inserted Successfully. } @ if (TempData[ "Message" ] == "Already" ) { "color:orangered;" > Client Master Details Already Exists. } } "text/javascript" src= "https://ajax.googleapis.com/ajax/libs/jquery/1.8.3/jquery.min.js" > "text/javascript" > $(function () { // This will make every element with the class "date-picker" into a DatePicker element $( '.date-picker' ).datepicker(); }) In My Controller part. public class ClientMasterController : Controller { SqlConnection con = new SqlConnection(ConfigurationManager.ConnectionStrings[ "PMSConn" ].ConnectionString); // GET: ClientMaster public ActionResult Index() { return View(ShowClientMaster()); } public ActionResult getClientId() { ClientMaster objCliMas = new ClientMaster(); DataSet ds = new DataSet(); string sQuery = " SELECT ISNULL(MAX(ClientId), 0)+1 'MaxClientId' FROM PMS_ClientMaster " ; SqlDataAdapter da = new SqlDataAdapter(sQuery, con); con.Open(); da.Fill(ds); con.Close(); if (ds.Tables[0].Rows.Count > 0) { objCliMas.Id = Convert.ToInt32(ds.Tables[0].Rows[0][ "MaxClientId" ].ToString()); } return View(objCliMas); } public List getClientList() { ClientMaster objCliMas = new ClientMaster(); DataSet ds = new DataSet(); string sQuery = "SELECT A.BranchCode,A.ClientId,A.ClntName,A.ClntAddress,B.ClntType FROM mstrClient AS A " + " LEFT JOIN mstrClientName AS B ON A.ClientId = B.ClientId AND A.ClntName = B.ClntName AND A.BranchCode = B.BranchCode " + " WHERE B.BranchCode = 'HSR-01' AND B.ClntType = 'Private' AND A.ClntStatus = 'Y' ORDER BY A.ClientId" ; SqlCommand cmd = new SqlCommand(sQuery, con); con.Open(); SqlDataAdapter da = new SqlDataAdapter(cmd); da.Fill(ds); con.Close(); List ClientLists = new List (); for ( int i = 0; i { ClientMaster CMobj = new ClientMaster(); CMobj.ClientId = Convert.ToInt32(ds.Tables[0].Rows[i][ "ClientId" ].ToString()); CMobj.ClientName = ds.Tables[0].Rows[i][ "ClntName" ].ToString(); ClientLists.Add(CMobj); } return ClientLists; } //public ActionResult getClientAddress(string sClientId) //{ // ClientMaster objClientList = new ClientMaster(); // DataSet ds = new DataSet(); // string sQuery = "SELECT A.BranchCode,A.ClientId,A.ClntName,A.ClntAddress,B.ClntType FROM mstrClient AS A " // + " LEFT JOIN mstrClientName AS B ON A.ClientId = B.ClientId AND A.ClntName = B.ClntName AND A.BranchCode = B.BranchCode " // + " WHERE B.BranchCode = 'HSR-01' AND B.ClntType = 'Private' AND A.ClntStatus = 'Y' AND B.ClientId = '" + sClientId.Trim() + "'"; // SqlDataAdapter da = new SqlDataAdapter(sQuery, con); // con.Open(); // da.Fill(ds); // con.Close(); // List ClientLists = new List (); // if (ds.Tables[0].Rows.Count > 0) // { // objClientList.ClientAddress = ds.Tables[0].Rows[0]["ClntAddress"].ToString(); // ClientLists.Add(objClientList); // } // return View("Create", objClientList); //} public ActionResult Create() { ClientMaster objCliMas = new ClientMaster(); TempData[ "Message" ] = "" ; //var ClientMasterId = getClientId(); //ViewBag.ClientIdLists = new SelectList(ClientMasterId, "Id"); //return View(objCliMas); var ClientMaster = getClientList(); ViewBag.ClientLists = new SelectList(ClientMaster, "ClientName" , "ClientId" , getClientId()); return View(objCliMas); } [HttpPost] public ActionResult Create(ClientMaster objCliMas) { try { var ClientMaster = getClientList(); ViewBag.ClientLists = new SelectList(ClientMaster, "ClientName" , "ClientId" , getClientId()); if (ModelState.IsValid) { string sReturn = string.Empty; SqlCommand cmd = new SqlCommand( "spPMS_ClientMaster" , con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue( "@QType" , "Insert" ); cmd.Parameters.AddWithValue( "@ClientId" , "" ); cmd.Parameters.AddWithValue( "@ClientName" , objCliMas.ClientName); cmd.Parameters.AddWithValue( "@ClientAddress" , objCliMas.ClientAddress); cmd.Parameters.AddWithValue( "@cStatus" , "Y" ); cmd.Parameters.AddWithValue( "@BranchCode" , "HSR-01" ); cmd.Parameters.AddWithValue( "@CreatedBy" , "Admin" ); SqlParameter SQLReturn = new SqlParameter( "@SQLReturn" , SqlDbType.NVarChar, 50); SQLReturn.Direction = ParameterDirection.Output; cmd.Parameters.Add(SQLReturn); con.Open(); cmd.ExecuteNonQuery(); con.Close(); sReturn = SQLReturn.Value.ToString().Trim(); if (sReturn.Trim() == "Success" ) { TempData[ "Message" ] = "Success" ; ModelState.Clear(); //getproductList(); //return View(objCliMas); return RedirectToAction( "ShowClientMaster" , "ClientMaster" ); } else if (sReturn.Trim() == "Already" ) { TempData[ "Message" ] = "Already" ; return View(); } else { TempData[ "Message" ] = "Some thing went wrong while User Created " ; return View(); } } else { return View(); } } catch (Exception ex) { TempData[ "Message" ] = ex; return View(); } } public ActionResult ShowClientMaster() { List ShowClientmaster = new List (); DataSet ds = new DataSet(); string sQuery = "SELECT ClientId,ClientName,ClientAddress FROM PMS_ClientMaster WHERE cStatus='Y' AND BranchCode='HSR-01'" ; SqlDataAdapter da = new SqlDataAdapter(sQuery, con); da.Fill(ds); if (ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { ShowClientmaster.Add( new ClientMaster() { Id = int .Parse(dr[0].ToString()), ClientName = dr[1].ToString(), ClientAddress = dr[2].ToString(), }); } return View(ShowClientmaster); } else { return RedirectToAction( "Create" ); } } public ActionResult EditClientMaster( int sClientId) { try { TempData[ "PRDId" ] = sClientId; ClientMaster objClient = new ClientMaster(); SqlDataAdapter da; DataSet ds = new DataSet(); da = new SqlDataAdapter( "SELECT * FROM PMS_ClientMaster WHERE ClientId = '" + sClientId + "'" , con); da.Fill(ds); var ClientMaster = getClientList(); ViewBag.ClientLists = new SelectList(ClientMaster, "ClientName" , "ClientId" ); for ( int i = 0; i { objClient.ClientId = int .Parse(ds.Tables[0].Rows[i][ "ClientId" ].ToString()); //objClient.ProductId = int.Parse(ds.Tables[0].Rows[i]["ProductId"].ToString()); objClient.ClientName = ds.Tables[0].Rows[i][ "ClientName" ].ToString(); objClient.ClientAddress = ds.Tables[0].Rows[i][ "ClientAddress" ].ToString(); } return View(objClient); } catch { return View(); } } [HttpPost] public ActionResult EditClientMaster(ClientMaster objPRD) { try { var ClientMaster = getClientList(); ViewBag.ClientLists = new SelectList(ClientMaster, "ClientId" , "ClientName" ); if (ModelState.IsValid) { string sReturn = string.Empty; SqlCommand cmd = new SqlCommand( "spPMS_ClientMaster" , con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue( "@QType" , "Update" ); cmd.Parameters.AddWithValue( "@ClientId" , objPRD.ClientId); cmd.Parameters.AddWithValue( "@ClientName" , objPRD.ClientName); cmd.Parameters.AddWithValue( "@ClientAddress" , objPRD.ClientAddress); cmd.Parameters.AddWithValue( "@cStatus" , "Y" ); cmd.Parameters.AddWithValue( "@BranchCode" , "HSR-01" ); cmd.Parameters.AddWithValue( "@CreatedBy" , "Admin" ); SqlParameter SQLReturn = new SqlParameter( "@SQLReturn" , SqlDbType.NVarChar, 50); SQLReturn.Direction = ParameterDirection.Output; cmd.Parameters.Add(SQLReturn); con.Open(); cmd.ExecuteNonQuery(); con.Close(); sReturn = SQLReturn.Value.ToString().Trim(); if (sReturn.Trim() == "Success" ) { //TempData["Message"] = "Success"; ModelState.Clear(); return RedirectToAction( "ShowClientMaster" , "ClientMaster" ); } else if (sReturn.Trim() == "Already" ) { TempData[ "Message" ] = "Already" ; return View(); } else { TempData[ "Message" ] = "Some thing went wrong while User Created " ; return View(); } } else { return View(); } } catch (Exception ex) { TempData[ "Message" ] = ex; return View(); } } public ActionResult Delete( int sClientId) { try { // mstrProduct objProduct = new mstrProduct(); string sQuery = "UPDATE PMS_ClientMaster SET cStatus = 'N' WHERE ClientId ='" + sClientId + "'" ; SqlCommand cmd = new SqlCommand(sQuery, con); con.Open(); cmd.ExecuteNonQuery(); con.Close(); return RedirectToAction( "ShowClientMaster" ); } catch { return View(); } } } So what are all changes I should do to my code, please let me know it.

Sourav Kumar Das · Answer

Hi, My question is while selecting one of the dropdown list value at on selected change event the textbox should be binded. Example: dropdownlist has all the client names while selecting one of the client name the textbox should return its client address based on the client name selected.