Creating Lookup Lists with LINQ to SQL

Airline Travel » Creating Lookup Lists with LINQ to SQL

Airline Travel » Creating Lookup Lists with LINQ to SQL — Thu, 07 Feb 2008 22:41:19 GMT

PingBack from http://www.travel-hilarity.com/airline_travel/?p=1295

re: Creating Lookup Lists with LINQ to SQL

Steven — Fri, 08 Feb 2008 14:58:34 GMT

Thanks for this Post!

I've done everything as you described, but when I run my application always the first entry in the territorieslist doesn't change the Combobox to the right value. the other entries work, but first one always shows the first entry in the Regionlist instaed of the one that belobgs to this entry.

Maybe you have an Idea.

Thanks Steven

re: Creating Lookup Lists with LINQ to SQL

Beth Massi — Fri, 08 Feb 2008 23:08:58 GMT

Hi Steven,

Did you make sure you set the ValueMember of the Combobox to the RegionID?

Beth Massi on LINQ DataBinding to ComboBoxes

Hot Topics — Mon, 11 Feb 2008 03:18:18 GMT

Two recent LINQ databinding with ComboBoxes posts from Beth Massi of the Visual Basic team. Creating

re: Creating Lookup Lists with LINQ to SQL

KK — Tue, 12 Feb 2008 09:00:01 GMT

With WinForm on the way out & WPF the new kid in the block, using WPF would be wonderful

re: Creating Lookup Lists with LINQ to SQL

Beth Massi — Tue, 12 Feb 2008 21:09:34 GMT

Hi KK,

I'll put it on the list ;-). I wanted to start with Winforms because the visual designers are much better and it's easier to understand.

In the meantime check out www.windowsclient.net

Cheers,

-B

One-To-Many (Master-Detail) Forms with LINQ to SQL

Beth Massi - Sharing the goodness that is VB — Wed, 20 Feb 2008 02:11:16 GMT

In my previous posts here and here I showed how to use LINQ to SQL classes with a couple different Combobox

Simple Validation with LINQ to SQL Classes

Beth Massi - Sharing the goodness that is VB — Tue, 26 Feb 2008 04:04:28 GMT

In the last few posts on LINQ to SQL I've showed how to set up an object model using the O/R designer

Simple Validation with LINQ to SQL Classes

Noticias externas — Tue, 26 Feb 2008 04:29:17 GMT

In the last few posts on LINQ to SQL I've showed how to set up an object model using the O/R designer

re: Creating Lookup Lists with LINQ to SQL

saleem — Thu, 06 Mar 2008 12:35:08 GMT

hi , my name is saleem

can you answer my qestions please

1- i made a simple media player to play sound and video i just want to know how can i get all file names

i selected and pressed enter

i tried a startupnextinstance event

and i got all file names but this was a very slow way and doesn't work well when you have alot of files (more than 100)

i think i should use somthing exist in windows

i think somthing related to user32.dll or another file

please can you tell me what the way is

( i want the same way that is used in windows media player to open many files)

2-i can drag and drop files from explorer to my play list using dragdrop event but this doesn't work when i drag files from openfiledialog to my playlist

my listbox doesn't feel dragdrop event

3- how can i next the song using nextmediabutton

while my application is minimized and i am working on another program

4- sorry if my English is not very good

and thank you for every thing

LINQ to SQL N-Tier Smart Client - Part 1 Building the Middle-Tier

Beth Massi - Sharing the goodness that is VB — Sat, 12 Apr 2008 19:27:12 GMT

In my previous posts on LINQ to SQL I showed how to build LINQ to SQL classes and set up the data binding

re: Creating Lookup Lists with LINQ to SQL

ama — Tue, 06 May 2008 15:44:09 GMT

Hi Beth

This code doesn't work

I Have this

Me.RegionIDComboBox.DataBindings.Add(New System.Windows.Forms.Binding("SelectedValue", Me.TerritoriesBindingSource, "RegionID", True))

Me.RegionIDComboBox.DataSource = Me.RegionBindingSource

Me.RegionIDComboBox.DisplayMember = "RegionDescription"

Me.RegionIDComboBox.DropDownStyle = System.Windows.Forms.ComboBoxStyle.DropDownList

Me.RegionIDComboBox.FormattingEnabled = True

Me.RegionIDComboBox.Location = New System.Drawing.Point(131, 56)

Me.RegionIDComboBox.Name = "RegionIDComboBox"

Me.RegionIDComboBox.Size = New System.Drawing.Size(145, 21)

Me.RegionIDComboBox.TabIndex = 6

Me.RegionIDComboBox.ValueMember = "RegionID"

but when I change value in cmbBox nothing happens

re: Creating Lookup Lists with LINQ to SQL

Beth Massi — Sat, 10 May 2008 01:43:44 GMT

Hi Ama,

You need to make sure you call EndEdit() on the bindingsource before you call SubmitChanges. Take a look at the code snippet above for the save button.

HTH,

-B

re: Creating Lookup Lists with LINQ to SQL

Shawn — Thu, 15 May 2008 19:04:43 GMT

Hello Beth,

I am developing an application in Visual Basic 6 with Farpoint Spread as an Active X Control which contains my table data. I began teaching myself code middle of last year to transform an excel application into a fully executable program. I used the Vlookup funtion in Excel in many aspects and am needing to do the same in VB6 but have not been able to find anything on this. If you could spare some of your time to offer me help on this, I would greatly appreciate it.

Sincerely,

Shawn Guillory

President & Founder

Guillory's Technical Consulting

spgtechconsulting@yahoo.com

re: Creating Lookup Lists with LINQ to SQL

Ahmed — Sat, 13 Sep 2008 03:40:36 GMT

Hi Beth,

For this code works properly, we must fill the Regions before the Territories , otherwise, like Steven said, the first entry in the territorieslist will be always 1 and will be in the state of updated.

Example:

territoriesBindingSource.DataSource =

from t in db.Territories

where t.RegionID == 3

select t;

regionBindingSource.DataSource = db.Regions;

re: Creating Lookup Lists with LINQ to SQL

Emmanuel Nuyttens — Mon, 06 Oct 2008 13:06:05 GMT

Hi Beth,

First of all, many thanx for providing us this information in a fluent & easy to understand way. Fortunatelly, some people tend to explain those stuff in a to complicated way.

I have the same problem concerning the filtering of territories to the selected region, and all prop's are properly binded !

So my solution was to handle the "SelectedIndexChanged" of the region combo as next:

public FormTerritory()

{

InitializeComponent();

territoriesBindingSource.DataSource = _db.Territories;

regionBindingSource.DataSource = _db.Regions;

// Get the Current RegionId && Filter the Territories

if (regionIDComboBox.Items.Count > 0)

{

FilterTerritories(Int32.Parse(regionIDComboBox.SelectedValue.ToString()));

}

private void regionIDComboBox_SelectedIndexChanged(object sender, EventArgs e)

{

// Get the Current RegionId && Filter the Territories

if (regionIDComboBox.Items.Count > 0)

{

FilterTerritories(Int32.Parse(regionIDComboBox.SelectedValue.ToString()));

}

private void FilterTerritories(int p_regionId)

{

territoriesBindingSource.DataSource =

from territory in _db.Territories

where territory.RegionID == p_regionId

select territory;

}

Greetz & keep going on posting those nice articles !

Emmanuel Nuyttens

.NET Architect Alsico NV.

BELGIUM (Ronse)

Data Binding WPF Lookup Combobox Values to EF Entities

Beth Massi - Sharing the goodness that is VB — Fri, 01 May 2009 20:18:52 GMT

It’s extremely common to have to hook up lookup tables on your data entry forms in order to populate

re: Creating Lookup Lists with LINQ to SQL

basheer — Wed, 13 May 2009 13:45:13 GMT

This is a very surpprising style it is the best new techniqe in software developement

re: Creating Lookup Lists with LINQ to SQL

j halsey — Tue, 04 Aug 2009 15:41:48 GMT

How would I do this if I had 2 look up columns in a single table that were tied to two seperate tables?

re: Creating Lookup Lists with LINQ to SQL

jhalsey — Tue, 04 Aug 2009 16:25:08 GMT

I need to do this in C#. Any tips?

re: Creating Lookup Lists with LINQ to SQL

Beth Massi — Tue, 04 Aug 2009 20:28:45 GMT

Hi jhalsey,

You would repeat the same process for two lookup tables. And there's nothing special you have to do to support C# here.

Have fun,

-B

re: Creating Lookup Lists with LINQ to SQL

JohnMurray — Tue, 20 Oct 2009 22:00:27 GMT

When I try to follow the code here, I get an exception:

foreignkeyreferencealreadyhasvalue. If I add the item to the list associated with the foreignkey element, then all goes well. however, when I try to have the combo box set the foreign key directly, i get an exception. Am I looking at this incorreclty?

thanks,

John

re: Creating Lookup Lists with LINQ to SQL

JohnMurray — Wed, 21 Oct 2009 04:10:04 GMT

After very carefully following the tutorial, I was able to correct my problem. I created several combo boxes on the same page, each based off of a different parent table, using the same binding source for the child table (territoriesBindingSource). All worked as advertised. Thank you for a wonderful tutorial!!!