How to display combination of columns as display member?

Question

I have the following code :

private void LoadCombos()
{
    //
    //Entity
    cmbEntity.ValueMember = "ID";
    cmbEntity.DisplayMember = "Name";
    cmbEntity.DataSource = store.Entities; //store is an objectContext
    //
}

I am trying to display Name as well as ID using this :

cmbEntity.DisplayMember = "ID+Name";

Is there a way by which I can achieve this, so as to display ID as well as name in combobox?

You can't do it like this way, you have to update the data in datasource. — Naveen, Jan 29 '14 at 05:29

Hamlet Hakobyan · Accepted Answer · 2014-01-29T13:42:21.610

2

Try this:

cmbEntity.DataSource =
             store.Entities
                     .ToList()
                     .Select(e => new {Id = e.Id, Name = e.Id + e.Name});

or you can use

cmbEntity.DataSource =
     store.Entities
          .Select(e => new {Id = e.Id,
                     Name = SqlFunctions.StringConvert((decimal)e.Id + e.Name});

In this case you must add reference to assembly System.Data.Entity.dll and import namespace System.Data.Objects.SqlClient.

edited Jan 29 '14 at 13:42

answered Jan 29 '14 at 05:31

Hamlet Hakobyan

32,965
6
52
68

@PrakashVishwakarma Add `ToList()` to end. Did the combo populated when you use your code? – Hamlet Hakobyan Jan 29 '14 at 05:59
No combo is not populated with any data, tried ToList as well – Prakash Vishwakarma Jan 29 '14 at 06:06
Yes it populates data with my existing code which i have mentioned in my question cmbEntity.DataSource = store.Entities; – Prakash Vishwakarma Jan 29 '14 at 06:08
It gives error : Unable to cast the type 'System.Int64' to type 'System.Object'. LINQ to Entities only supports casting EDM primitive or enumeration types. – Prakash Vishwakarma Jan 29 '14 at 06:09
None of above works, even after the newly updated change by you. – Prakash Vishwakarma Jan 31 '14 at 09:08
What does it mean? You have error or the result is that not you expected. – Hamlet Hakobyan Jan 31 '14 at 09:13
The only issue is above code does not populate any data – Prakash Vishwakarma Jan 31 '14 at 09:14
Try to add `ToList()` to end of the query. – Hamlet Hakobyan Jan 31 '14 at 09:54

score 0 · Answer 2 · edited May 23 '17 at 10:31

0

Similar to this question is already answered here containing one of the ways you can achieve it using Dictionary

var dict = new Dictionary<Guid, string>();
foreach (var row in dt.Rows)
{
    dict.Add(row["GUID"], row["Name"] + " " + row["Surname"]);
}
cbo.DataSource = dict;
cbo.DataTextField = "Value";
cbo.DataValueField = "Key";
cbo.DataBind();

edited May 23 '17 at 10:31

Community

1
1

answered Jan 29 '14 at 05:28

Jibran Khan

3,236
4
37
50

Combobox dowsn't have DataTextField and DatavalueField properties – Prakash Vishwakarma Jan 29 '14 at 05:47

How to display combination of columns as display member?

2 Answers2