Get the dropdown list of selected value and text in MVC

Sourav Kumar Das

7y22.8k.NET

How to get dropdownlist selected value and selected list while submitting of form in ASP.Net MVC without using EF?

If there's any solution please let me know.

9 Replies

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

Sreekanth Reddy7y ago
Accepted answer
Hi,

Adjust the parameters of the following line :

ViewBag.ClientLists = new SelectList(ClientMaster, "ClientId", "ClientName", 1);

Change it to :

ViewBag.ClientLists = new SelectList(ClientMaster, "ClientName", "ClientId", 1);

Thank you.
+1
Sreekanth Reddy7y ago
Did you got the answer ?
0
Sreekanth Reddy7y ago
Hi,
You cant fetch both text and value from the dropdownlist directly via models. As they point only one property.
In that case try to merge your value with txt by separator as like below :
public ActionResult EcgBilling()
{
var model = new SelectBillingSiteReportModel
{
Sites = new List
{
new SelectListItem {Text = "One", Value = "One:1"},
new SelectListItem {Text = "Two", Value = "Two:2"},
new SelectListItem {Text = "Three", Value = "Three:3"},
}
};
return View(model);
}
[HttpPost]
public ActionResult EcgBilling(SelectBillingSiteReportModel model)
{
string[] array = model.SelectedSiteKey.Split(':');
string text = array[0];
string value = array[1];
return View();
}
Mark as answer, If it helps.
Thank you.
+1
Sourav Kumar Das7y ago
Hi,

I have got the following answer by your changes.

ViewBag.ClientLists = new SelectList(ClientMaster, "ClientName", "ClientId", 1);

At View Side
But while binding the dropdownlist i am getting only clientid not the clientname.

@Sreekanth Reddy

0
Sourav Kumar Das7y ago
This is the code for ViewBag.ClientLists
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 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, "ClientId", "ClientName", 1);
return View(objCliMas);
}
@ Sreekanth Reddy
0
Sreekanth Reddy7y ago
Hi,

Please show your code for :

ViewBag.ClientLists

In Controller.

Thank you.
0
Sourav Kumar Das7y ago
I am showing you the sample code of it.
For Controller:
cmd.Parameters.AddWithValue("@ClientName", objCliMas.ClientName);
cmd.Parameters.AddWithValue("@ClientAddress", objCliMas.ClientAddress);

In this "objCliMas.ClientName" I am getting only value of the dropdown list at the database.

For view:

@Html.DropDownListFor(m => m.ClientName, (IEnumerable)ViewBag.ClientLists, "Select Client Name",
new { @class = "form-control" })

@Sreekanth Reddy
0
Sanwar Ranwa7y ago
Hello Sourav

Check these Links

https://www.aspsnippets.com/Articles/ASPNet-MVC-Get-DropDownList-Selected-Text-and-Selected-Value-in-Controller.aspx

https://www.c-sharpcorner.com/article/dropdownlist-in-asp-net-mvc/

https://nimblegecko.com/using-simple-drop-down-lists-in-ASP-NET-MVC/
+2
Sreekanth Reddy7y ago
Hi Sourav,

Let us think with the following scenario :
In View :
@Html.DropDownListFor(m=>m.SelectedVendor , Model.Vendor, "Select Manufacurer")
@Html.HiddenFor(m=>m.SelectedvendorText)
Whenever you do httppost by clicking "Submit" button, The httppost with parameter of type model propety SelectedVendor will be having the data. Directly you can access the value.
public ActionResult InsertValue(Vendor venobj)
{
//Here you can get dropdownlist value by assigned property directly
var x = venobj.Selectedvendor;
}
Mark as answer, If it helps.
Thank you.

+1