Loading

How to load dropdownbox with 2 value?

How to load dropdownbox with 2 value?

Niyazi Toros

10y867.NET

Hi,

In below code I need to get CustomerSurname as well. In the dropdown box I must show customer surname as: "CustomerName" + " " + "CustomerSurname".

// GET: APPROVALs/Create
public ActionResult Create()
{
ViewBag.CUSTID = new SelectList(db.CUSTOMER, "CUSTID", "CustomerName");
return View();
}

I also need the "db.CUSTOMER" must only get a customer list where CustomerActive = False...

Any help please,

Kind Regards,

4 Replies

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

Ravi Patel10y ago
Accepted answer
Hi,
try this
public ActionResult Create()
{
ViewBag.CUSTID = new SelectList(db.CUSTOMER.Where(m=>m.CustomerActive ==false).Select(m=>new{CUSTID=m.CUSTID,CustomerName=m.CustomerName+" "+ m.CustomerSurname}), "CUSTID", "CustomerName");
return View();
}
Niyazi Toros10y ago
Sorry Ravi,
Your code is working. My mistake. The value of theCustomerActive was Null on SQL.
I took part of yor code and put it the code that I found.
ViewBag.CUSTID=db.CUSTOMER.Where(m=>m.CustomerActive!=true).ToList().Select(c=>newSelectListItem
{
Value=c.CUSTID.ToString(),
Text=string.Format("{0}{1}",c.CustomerName,c.CustomerSurname)
});
returnView();
Now is working as I ecpected.
Kind Regards
Niyazi Toros10y ago
Hi Ravi,
Result is empty when I run your code. The code that I found
ViewBag.CUSTID=db.CUSTOMER.ToList().Select(c=>newSelectListItem
{
Value=c.CUSTID.ToString(),
Text=string.Format("{0}{1}",c.CustomerName,c.CustomerSurname)
});
returnView();
works perfectly. My question is that how can I use part of your code
Where(m=>m.CustomerActive==false)
in above code that I found?
Kind Regards
Niyazi Toros10y ago
Here is the solution.
//GET:APPROVALs/Create
publicActionResultCreate()
{
//ViewBag.CUSTID=newSelectList(db.CUSTOMER,"CUSTID","CustomerName");
//returnView();
ViewBag.CUSTID=db.CUSTOMER.ToList().Select(c=>newSelectListItem
{
Value=c.CUSTID.ToString(),
Text=string.Format("{0}{1}",c.CustomerName,c.CustomerSurname)
});
returnView();
}