Linq to SQL selecting from relation table

Question

0.00/5 (No votes)

See more:

I have, multiple tables,

HTML

division,
department,
group,
user

each of these have name and id

in another table(usergroupings) i have

HTML

userID
groupID
divisionID
departmentID

which are all foreign keys to the primary tables

this links a user id to a division department and group

now using Linq, i want to be able to populate,
a combo box with the group name etc,
and insert the id into(usergroupings)

I can see the relationed tables in (usergroupings),
but it does not populate the combo box with the values.

C#

dbs = new dbConnDataContext();

var userGrouping =
  from c in dbs.UserGroupings
  select c;

Posted 7-Oct-12 22:20pm

Miguelribeiro

Updated 7-Oct-12 22:21pm

Kenneth Haugland

v2

Add a Solution

Comments

Erik Rude 8-Oct-12 4:26am

Are you using Windows Forms or WPF and what code are you using to bind?

Miguelribeiro 8-Oct-12 4:40am

HI Erik,
Windows forms,

navUserGroupings.DataSource = userGrouping;
groupComboBox.DisplayMember = "Group.GroupName";
groupComboBox.ValueMember = "Group.ID";

and im using component one input panel control

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)

Mohd. Mukhtar · Answer 1 · 2012-10-07T22:41:00

Solution 1

modify your query as below.

C#

var userGrouping =
  from c in dbs.UserGroupings
  select c;
//Bind combobox after the making the list as below.
userGrouping.List();

for more please refer the below link

LINQ to SQL[^]

Hope this will help you.

Posted 7-Oct-12 22:41pm

Mohd. Mukhtar

Updated 7-Oct-12 22:42pm

v2

Comments

Miguelribeiro 8-Oct-12 5:21am

Hi,
ive tried that and still no luck,

Mohd. Mukhtar 8-Oct-12 5:26am

use the below query

var userGrouping =
from c in dbs.UserGroupings
select new{c.*give the column name here.};
//Bind combobox after the making the list as below.
userGrouping.List();