How to show multiple fields in combobox using linq in C# Windows form?
3
I want to show at least two column like FirstName and Lastname as DisplayMember and username as ValueMember from my Sql database. I tried like this but not working. It's working only with one field, but not if I want to show both Firstname and Lastname.
public void Employees()
{
db = new DbEntities();
var emp = (from u in db.Users
select u).ToList();
cmbEmployee.DisplayMember = "FirstName" +" " + " LastName";
cmbEmployee.ValueMember = "UserName";
cmbEmployee.DataSource = emp;
}
c# linq combobox
asked Nov 13 '18 at 18:09
Helen TekieHelen Tekie
140119
add a comment |
3
I want to show at least two column like FirstName and Lastname as DisplayMember and username as ValueMember from my Sql database. I tried like this but not working. It's working only with one field, but not if I want to show both Firstname and Lastname.
public void Employees()
{
db = new DbEntities();
var emp = (from u in db.Users
select u).ToList();
cmbEmployee.DisplayMember = "FirstName" +" " + " LastName";
cmbEmployee.ValueMember = "UserName";
cmbEmployee.DataSource = emp;
}
c# linq combobox
asked Nov 13 '18 at 18:09
Helen TekieHelen Tekie
140119
add a comment |
3
3
3
I want to show at least two column like FirstName and Lastname as DisplayMember and username as ValueMember from my Sql database. I tried like this but not working. It's working only with one field, but not if I want to show both Firstname and Lastname.
public void Employees()
{
db = new DbEntities();
var emp = (from u in db.Users
select u).ToList();
cmbEmployee.DisplayMember = "FirstName" +" " + " LastName";
cmbEmployee.ValueMember = "UserName";
cmbEmployee.DataSource = emp;
}
c# linq combobox
asked Nov 13 '18 at 18:09
Helen TekieHelen Tekie
140119
I want to show at least two column like FirstName and Lastname as DisplayMember and username as ValueMember from my Sql database. I tried like this but not working. It's working only with one field, but not if I want to show both Firstname and Lastname.
public void Employees()
{
db = new DbEntities();
var emp = (from u in db.Users
select u).ToList();
cmbEmployee.DisplayMember = "FirstName" +" " + " LastName";
cmbEmployee.ValueMember = "UserName";
cmbEmployee.DataSource = emp;
}
c# linq combobox
c# linq combobox
asked Nov 13 '18 at 18:09
Helen TekieHelen Tekie
140119
asked Nov 13 '18 at 18:09
Helen TekieHelen Tekie
140119
asked Nov 13 '18 at 18:09
Helen TekieHelen Tekie
140119
asked Nov 13 '18 at 18:09
Helen TekieHelen Tekie
140119
asked Nov 13 '18 at 18:09
Helen TekieHelen Tekie
140119
140119
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
1
Just join firstname and lastname in you linq query:
var emp = db.Users.Select(x=> $"{x.FirstName} {x.LastName}").ToList();
cmbEmployee.DataSource = emp;
Edit (considering your comment):
var emp = db.Users.Select(x=> new {
Display = x.FirstName + " " + x.LastName,
Value = x.UserName}).ToList();
cmbEmployee.DisplayMember = "Display";
cmbEmployee.ValueMember = "Value";
cmbEmployee.DataSource = emp;
answered Nov 13 '18 at 18:14
Ashkan Mobayen KhiabaniAshkan Mobayen Khiabani
20.3k1565115
Mobayen thenk you for response. but Iget error System.NotSupportedException: 'LINQ to Entities does not recognize the method . I get this error in the first row db.users.select...... How ca nO solve this problem? The second questoin is how to formulate then DisplayMember and ValueMember? Thank you
– Helen Tekie
Nov 13 '18 at 20:30
@HelenTekie, may be your c# version is old, try it like this:var emp = db.Users.Select(x=> x.FirstName + " " +x.LastName).ToList();
– Ashkan Mobayen Khiabani
Nov 13 '18 at 20:39
Mobayen , thank you now Firstname and lastname displaying but even the yare as value. But I want username as value. I mean FirstName and LastName as DisplayMember and Username as ValueMember. Right now even ValeMember is FirstName and LastName. Thank you again
– Helen Tekie
Nov 13 '18 at 20:47
@HelenTekie I edited my answer. plase have a look
– Ashkan Mobayen Khiabani
Nov 13 '18 at 20:56
Yes now it's working ...Thank you very much!
– Helen Tekie
Nov 13 '18 at 21:01
|
show 1 more comment
0
If you can modify the User class you have two options:
1) Override the ToString method and don't specify a DisplayMember:
public override string ToString()
{
return FirstName + " " + LastName;
}
2) Provide a property (e.g FirstAndLast) and set that as your DisplayMember:
public string FirstAndLast { get => FirstName + " " + LastName; }
answered Nov 13 '18 at 18:21
MikeHMikeH
3,268928
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53287102%2fhow-to-show-multiple-fields-in-combobox-using-linq-in-c-sharp-windows-form%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
1
Just join firstname and lastname in you linq query:
var emp = db.Users.Select(x=> $"{x.FirstName} {x.LastName}").ToList();
cmbEmployee.DataSource = emp;
Edit (considering your comment):
var emp = db.Users.Select(x=> new {
Display = x.FirstName + " " + x.LastName,
Value = x.UserName}).ToList();
cmbEmployee.DisplayMember = "Display";
cmbEmployee.ValueMember = "Value";
cmbEmployee.DataSource = emp;
answered Nov 13 '18 at 18:14
Ashkan Mobayen KhiabaniAshkan Mobayen Khiabani
20.3k1565115
Mobayen thenk you for response. but Iget error System.NotSupportedException: 'LINQ to Entities does not recognize the method . I get this error in the first row db.users.select...... How ca nO solve this problem? The second questoin is how to formulate then DisplayMember and ValueMember? Thank you
– Helen Tekie
Nov 13 '18 at 20:30
@HelenTekie, may be your c# version is old, try it like this:var emp = db.Users.Select(x=> x.FirstName + " " +x.LastName).ToList();
– Ashkan Mobayen Khiabani
Nov 13 '18 at 20:39
Mobayen , thank you now Firstname and lastname displaying but even the yare as value. But I want username as value. I mean FirstName and LastName as DisplayMember and Username as ValueMember. Right now even ValeMember is FirstName and LastName. Thank you again
– Helen Tekie
Nov 13 '18 at 20:47
@HelenTekie I edited my answer. plase have a look
– Ashkan Mobayen Khiabani
Nov 13 '18 at 20:56
Yes now it's working ...Thank you very much!
– Helen Tekie
Nov 13 '18 at 21:01
|
show 1 more comment
1
Just join firstname and lastname in you linq query:
var emp = db.Users.Select(x=> $"{x.FirstName} {x.LastName}").ToList();
cmbEmployee.DataSource = emp;
Edit (considering your comment):
var emp = db.Users.Select(x=> new {
Display = x.FirstName + " " + x.LastName,
Value = x.UserName}).ToList();
cmbEmployee.DisplayMember = "Display";
cmbEmployee.ValueMember = "Value";
cmbEmployee.DataSource = emp;
answered Nov 13 '18 at 18:14
Ashkan Mobayen KhiabaniAshkan Mobayen Khiabani
20.3k1565115
Mobayen thenk you for response. but Iget error System.NotSupportedException: 'LINQ to Entities does not recognize the method . I get this error in the first row db.users.select...... How ca nO solve this problem? The second questoin is how to formulate then DisplayMember and ValueMember? Thank you
– Helen Tekie
Nov 13 '18 at 20:30
@HelenTekie, may be your c# version is old, try it like this:var emp = db.Users.Select(x=> x.FirstName + " " +x.LastName).ToList();
– Ashkan Mobayen Khiabani
Nov 13 '18 at 20:39
Mobayen , thank you now Firstname and lastname displaying but even the yare as value. But I want username as value. I mean FirstName and LastName as DisplayMember and Username as ValueMember. Right now even ValeMember is FirstName and LastName. Thank you again
– Helen Tekie
Nov 13 '18 at 20:47
@HelenTekie I edited my answer. plase have a look
– Ashkan Mobayen Khiabani
Nov 13 '18 at 20:56
Yes now it's working ...Thank you very much!
– Helen Tekie
Nov 13 '18 at 21:01
|
show 1 more comment
1
1
1
Just join firstname and lastname in you linq query:
var emp = db.Users.Select(x=> $"{x.FirstName} {x.LastName}").ToList();
cmbEmployee.DataSource = emp;
Edit (considering your comment):
var emp = db.Users.Select(x=> new {
Display = x.FirstName + " " + x.LastName,
Value = x.UserName}).ToList();
cmbEmployee.DisplayMember = "Display";
cmbEmployee.ValueMember = "Value";
cmbEmployee.DataSource = emp;
answered Nov 13 '18 at 18:14
Ashkan Mobayen KhiabaniAshkan Mobayen Khiabani
20.3k1565115
Just join firstname and lastname in you linq query:
var emp = db.Users.Select(x=> $"{x.FirstName} {x.LastName}").ToList();
cmbEmployee.DataSource = emp;
Edit (considering your comment):
var emp = db.Users.Select(x=> new {
Display = x.FirstName + " " + x.LastName,
Value = x.UserName}).ToList();
cmbEmployee.DisplayMember = "Display";
cmbEmployee.ValueMember = "Value";
cmbEmployee.DataSource = emp;
answered Nov 13 '18 at 18:14
Ashkan Mobayen KhiabaniAshkan Mobayen Khiabani
20.3k1565115
edited Nov 13 '18 at 20:56
answered Nov 13 '18 at 18:14
Ashkan Mobayen KhiabaniAshkan Mobayen Khiabani
20.3k1565115
answered Nov 13 '18 at 18:14
Ashkan Mobayen KhiabaniAshkan Mobayen Khiabani
20.3k1565115
answered Nov 13 '18 at 18:14
Ashkan Mobayen KhiabaniAshkan Mobayen Khiabani
20.3k1565115
20.3k1565115
Mobayen thenk you for response. but Iget error System.NotSupportedException: 'LINQ to Entities does not recognize the method . I get this error in the first row db.users.select...... How ca nO solve this problem? The second questoin is how to formulate then DisplayMember and ValueMember? Thank you
– Helen Tekie
Nov 13 '18 at 20:30
@HelenTekie, may be your c# version is old, try it like this:var emp = db.Users.Select(x=> x.FirstName + " " +x.LastName).ToList();
– Ashkan Mobayen Khiabani
Nov 13 '18 at 20:39
Mobayen , thank you now Firstname and lastname displaying but even the yare as value. But I want username as value. I mean FirstName and LastName as DisplayMember and Username as ValueMember. Right now even ValeMember is FirstName and LastName. Thank you again
– Helen Tekie
Nov 13 '18 at 20:47
@HelenTekie I edited my answer. plase have a look
– Ashkan Mobayen Khiabani
Nov 13 '18 at 20:56
Yes now it's working ...Thank you very much!
– Helen Tekie
Nov 13 '18 at 21:01
|
show 1 more comment
Mobayen thenk you for response. but Iget error System.NotSupportedException: 'LINQ to Entities does not recognize the method . I get this error in the first row db.users.select...... How ca nO solve this problem? The second questoin is how to formulate then DisplayMember and ValueMember? Thank you
– Helen Tekie
Nov 13 '18 at 20:30
@HelenTekie, may be your c# version is old, try it like this:var emp = db.Users.Select(x=> x.FirstName + " " +x.LastName).ToList();
– Ashkan Mobayen Khiabani
Nov 13 '18 at 20:39
Mobayen , thank you now Firstname and lastname displaying but even the yare as value. But I want username as value. I mean FirstName and LastName as DisplayMember and Username as ValueMember. Right now even ValeMember is FirstName and LastName. Thank you again
– Helen Tekie
Nov 13 '18 at 20:47
@HelenTekie I edited my answer. plase have a look
– Ashkan Mobayen Khiabani
Nov 13 '18 at 20:56
Yes now it's working ...Thank you very much!
– Helen Tekie
Nov 13 '18 at 21:01
Mobayen thenk you for response. but Iget error System.NotSupportedException: 'LINQ to Entities does not recognize the method . I get this error in the first row db.users.select...... How ca nO solve this problem? The second questoin is how to formulate then DisplayMember and ValueMember? Thank you
– Helen Tekie
Nov 13 '18 at 20:30
Mobayen thenk you for response. but Iget error System.NotSupportedException: 'LINQ to Entities does not recognize the method . I get this error in the first row db.users.select...... How ca nO solve this problem? The second questoin is how to formulate then DisplayMember and ValueMember? Thank you
– Helen Tekie
Nov 13 '18 at 20:30
@HelenTekie, may be your c# version is old, try it like this:
var emp = db.Users.Select(x=> x.FirstName + " " +x.LastName).ToList();– Ashkan Mobayen Khiabani
Nov 13 '18 at 20:39
@HelenTekie, may be your c# version is old, try it like this:
var emp = db.Users.Select(x=> x.FirstName + " " +x.LastName).ToList();– Ashkan Mobayen Khiabani
Nov 13 '18 at 20:39
Mobayen , thank you now Firstname and lastname displaying but even the yare as value. But I want username as value. I mean FirstName and LastName as DisplayMember and Username as ValueMember. Right now even ValeMember is FirstName and LastName. Thank you again
– Helen Tekie
Nov 13 '18 at 20:47
Mobayen , thank you now Firstname and lastname displaying but even the yare as value. But I want username as value. I mean FirstName and LastName as DisplayMember and Username as ValueMember. Right now even ValeMember is FirstName and LastName. Thank you again
– Helen Tekie
Nov 13 '18 at 20:47
@HelenTekie I edited my answer. plase have a look
– Ashkan Mobayen Khiabani
Nov 13 '18 at 20:56
@HelenTekie I edited my answer. plase have a look
– Ashkan Mobayen Khiabani
Nov 13 '18 at 20:56
Yes now it's working ...Thank you very much!
– Helen Tekie
Nov 13 '18 at 21:01
Yes now it's working ...Thank you very much!
– Helen Tekie
Nov 13 '18 at 21:01
|
show 1 more comment
0
If you can modify the User class you have two options:
1) Override the ToString method and don't specify a DisplayMember:
public override string ToString()
{
return FirstName + " " + LastName;
}
2) Provide a property (e.g FirstAndLast) and set that as your DisplayMember:
public string FirstAndLast { get => FirstName + " " + LastName; }
answered Nov 13 '18 at 18:21
MikeHMikeH
3,268928
add a comment |
0
If you can modify the User class you have two options:
1) Override the ToString method and don't specify a DisplayMember:
public override string ToString()
{
return FirstName + " " + LastName;
}
2) Provide a property (e.g FirstAndLast) and set that as your DisplayMember:
public string FirstAndLast { get => FirstName + " " + LastName; }
answered Nov 13 '18 at 18:21
MikeHMikeH
3,268928
add a comment |
0
0
0
If you can modify the User class you have two options:
1) Override the ToString method and don't specify a DisplayMember:
public override string ToString()
{
return FirstName + " " + LastName;
}
2) Provide a property (e.g FirstAndLast) and set that as your DisplayMember:
public string FirstAndLast { get => FirstName + " " + LastName; }
answered Nov 13 '18 at 18:21
MikeHMikeH
3,268928
If you can modify the User class you have two options:
1) Override the ToString method and don't specify a DisplayMember:
public override string ToString()
{
return FirstName + " " + LastName;
}
2) Provide a property (e.g FirstAndLast) and set that as your DisplayMember:
public string FirstAndLast { get => FirstName + " " + LastName; }
answered Nov 13 '18 at 18:21
MikeHMikeH
3,268928
answered Nov 13 '18 at 18:21
MikeHMikeH
3,268928
answered Nov 13 '18 at 18:21
MikeHMikeH
3,268928
answered Nov 13 '18 at 18:21
MikeHMikeH
3,268928
3,268928
add a comment |
add a comment |
draft saved
draft discarded
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53287102%2fhow-to-show-multiple-fields-in-combobox-using-linq-in-c-sharp-windows-form%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
