Related to Combo Box Binding using LINQ in winforms

Question

0.00/5 (No votes)

See more:

.NET3.5

Hi everyone :)

I would like to thank everyone who has replied for your help.

Now this question is related to binding and populating of a combobox using Linq

Let me just say that before LINQ I would do the following

1. Create a class with a static list that was generically typed to the class itself.

This class would have two properties. An ID and a customer name The ID was the value member of the combobox and the customer name was th display member.

2. Use a datareader to populate the class.

3. Set the datasource of the combobox as the static list in the class and the ID and customername as valuemember and the displaymember.

No problems with that?! Right?

This used to work just great.

Until LINQ

Now I have used LINQ extensively for other purposes. I have not been able to understand how to do populate a combobox using LINQ.

I have a stored procedure that I am calling using LINQ as follows

CustomerDataContext db = new CustomerDataContext();
List <ListCustomerResult>ListCustomerResults = new db.ListCustomer().Tolist<ListCustomerResult>()

Now the question is how do I use ListCustomerResults for populating the combobox?

Any inputs or ideas are most welcome. If there is an alternate means of populating or binding a combobox using LINQ thne do let me know

Regards

Posted 3-Sep-10 9:17am

RebornDeveloper

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Not Active · Accepted Answer · 2010-09-03T17:23:00

Solution 1

You have been doing it the hard way all along and there is no difference when using Linq.

combo.DisplayMember = "Name";
combo.ValueMember = "ID";
combo.DataSource = dataTable;

or

combo.DataSource = ListCustomerResults;

Posted 3-Sep-10 17:23pm

Not Active