How to load dropdownbox with 2 value?

Question

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,

Ravi Patel · 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 Toros · Answer

Here is the solution. //GET:APPROVALs/Create public ActionResultCreate() { //ViewBag.CUSTID=newSelectList(db.CUSTOMER,"CUSTID","CustomerName"); //returnView(); ViewBag.CUSTID=db.CUSTOMER.ToList().Select(c=> new SelectListItem { Value=c.CUSTID.ToString(), Text=string.Format( "{0}{1}" ,c.CustomerName,c.CustomerSurname) }); return View(); }

Niyazi Toros · Answer

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=> new SelectListItem { Value=c.CUSTID.ToString(), Text= string .Format( "{0}{1}" ,c.CustomerName,c.CustomerSurname) }); return View(); Now is working as I ecpected. Kind Regards

Niyazi Toros · Answer

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

How to load dropdownbox with 2 value?

Answers (4)