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.

Get Drop down List and bind the textbox values in MVC

Answers (7)