Related Data Binding and ComboBoxes with LINQ to SQL

re: Related Data Binding and ComboBoxes with LINQ to SQL

Mick C — Sun, 30 May 2010 03:36:24 GMT

Hi Beth,

I have a dataset containing 6 tables (Country, Region, Province, City, Suburb, Street) which have a relationship established on unique key down to the street level so the locality is related. When i use this dataset in a form (to store users location details in a separate dataset) and apply 6 combo boxes in a form to allow the user to select location, the details display ok but show all records from each datatable. In the combobox selected value change event for each combobox i have retrieved the selected keyid and then applied this in a fill query to obtain correct subset child data for the parent id selected. when i move to another record in the main binding source, the lookups in the 6 comboboxes do not display the data user has selected. I have been searching for an answer in particular through your video series but have been unable to find a solution to this problem. Hope you may be able to enlighten me

regards,

Mick C

re: Related Data Binding and ComboBoxes with LINQ to SQL

Beth Massi — Fri, 17 Jul 2009 19:16:37 GMT

Hi Jack,

I use live writer for everything. I just paste screen shots into the posts and it handles uploading them as pictures.

Cheers,

-B

re: Related Data Binding and ComboBoxes with LINQ to SQL

Jack Webb — Fri, 17 Jul 2009 05:26:14 GMT

Sorry for the delayed response, I'm in a different time zone! I saw you post re using Live Writer to paste VS code which includes formatting (see below).

I now wonder how you also paste dialog boxes as well.

tia

jjw

re: Related Data Binding and ComboBoxes with LINQ to SQL

Beth Massi — Tue, 07 Jul 2009 22:52:18 GMT

Hi Jerry,

You can just write a LINQ query to order the collection you want to bind to. For instance in the above example if I wanted to sort the Regions on RegionDescription field then I could do this:

Me.RegionComboBox.DataSource = Nothing

Dim sortedRegionList = (From r In db.Regions _

Order By r.RegionDescription).ToList()

Me.RegionBindingSource.DataSource = sortedRegionList

Me.RegionComboBox.DataSource = Me.RegionBindingSource

HTH,

-B

re: Related Data Binding and ComboBoxes with LINQ to SQL

Beth Massi — Tue, 07 Jul 2009 21:37:00 GMT

Hi Kevin,

When you drag-drop the tables from the data source window onto the Winform it will create the BindingSources for you on the form in the component tray. Take a look at these videos:

http://msdn.microsoft.com/en-us/vbasic/bb725824.aspx

http://msdn.microsoft.com/en-us/vbasic/cc138241.aspx

HTH,

-B

re: Related Data Binding and ComboBoxes with LINQ to SQL

Jerry — Tue, 07 Jul 2009 00:20:52 GMT

I have learned a lot from your blogs and videos. Sorry to dig up an old post, but just getting into LINQ to SL on Winforms. Been using it on webforms, mostly MVC.

The question I have is this, how can I sort the data prior to binding it to the combobox? I want to sort on customername (text) and customerid will be the value.

re: Related Data Binding and ComboBoxes with LINQ to SQL

Kevin Burton — Wed, 17 Jun 2009 21:13:16 GMT

I brought up the Data Sources window and I added some data sources and I don't get the equivalent of RegionBindingSource (or any code for that matter).

What am I doing wrong?

Data Binding WPF Lookup Combobox Values to EF Entities

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

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

re: Related Data Binding and ComboBoxes with LINQ to SQL

Waner Michaud — Fri, 20 Mar 2009 22:00:29 GMT

Hi Beth,

I have a form that has a IGPNHDataSet with three Related tables(Registration_Table, Complaint_Table, Offender_Table)

Relationship as follows: FK_complaint_ID, FK_offender_ID are both in the Registration_Table..

Registration Table:

Reg_ID as PK

Date

Complaint_ID

Offender_ID

Desc

Nature

Complaint Table:

complaint_Id as PK

lastname

firstname

phone

Offender Table:

Offender_ID

lastname

firstname

phone

etc..

Above is my tables structure.

On the form, I drag all the info for all three tables..

Onload, I get all the records from the tables..

when i click on NEW to do a new registration which will include new complainant and offender, the fields from the regitration table is cleared and i can enter new record

but for complainant and offender, no action is taking, i cannot enter new info for them.

Can you please guide me on what to do and need to save/update the records

if need be, send me some guidances at wnmichaud@yahoo.com

thanks..

re: Related Data Binding and ComboBoxes with LINQ to SQL

enrique.prados@a-e.es — Fri, 06 Feb 2009 18:34:48 GMT

Hi all,

How can I change color of a cell in datagridview in this issue:

- Linking BindingSource with DAtagridView

- When I add item in BindingSource I want change color of a new row inserted in DatagridView

Thanks in advance, kind regards