Get Drop down List and bind the textbox values in MVC

C# Corner

Sourav Kumar Das

7y9.9k.NET

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.

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Faisal Pathan7y ago
Accepted answer
1. $("#TEXTBOX-ID").val($(this).find("option:selected").val());
2. // or else make ajax call to retrive address
3. var client = $(this).find("option:selected").val();
4. $.ajax({
5. type: "GET",
6. url: "/Controller/Action",
7. data: { "name": client },
8. contentType: 'application/json; charset=utf-8',
9. success: function (response) {
10. if (response != null) {
11. $("#TEXTBOX-ID").val(response);
12. }
13. },
14. error: function (xhr, ajaxOptions, thrownError) {
15. alert('Failed to retrieve address.');
16. }
17. });
19. });
+1

Sreekanth Reddy7y ago

@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)"

});

In your controller :

[HttpPost]

public string postactionmethodname(string valIs)

{

//Code to get Address by ID

return "Address";

}

Faisal Pathan7y ago

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.

Sourav Kumar Das7y ago

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">
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 < ds.Tables[0].Rows.Count; 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 < ds.Tables[0].Rows.Count; 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.

Sreekanth Reddy7y ago

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 :

Mark as answer, If it helps.

Thank you.

Sourav Kumar Das7y ago

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.

Faisal Pathan7y ago

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

Get Drop down List and bind the textbox values in MVC

Client Master - Add