> Nope failed with DataGridView...moved to UltraGrid...failed on that as
> well....tried to create a relationship back to itself on the table, so
> that the object would appear as a column in itself.....failed in the
> Model designer.
Hmm.
In the devexpress grid I can create a dropdown combo with objects
which are returned (no valuemember set) and through databinding the property
in the cell is set to the object. But that's yet another grid indeed.... :)
You'd expect the EF to work with a vanilla datagridview..
FB
>
> > -----Original Message-----
> > From: Discussion of advanced .NET topics. [mailto:ADVANCED-
> > [EMAIL PROTECTED] On Behalf Of Nicholls, Mark
> > Sent: 05 September 2008 15:34
> > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
> > Subject: Re: [ADVANCED-DOTNET] DataGridViewComboBoxColumn and entity
> > framework....
> >
> > Thanks very much for that....I try to use the standard control when
> > possible but the datagrid thing is a complete pain at times...and
> gives
> > little clue of what the real problem is...inner exception is always
> > blank.
> >
> > I managed previously to get this working with Linq2SQL....with much
> > wrestling it eventually did something sensible....so I just naively
> > tried to implement the same approach, but as you say it doesn't map
> the
> > key fields in the same way.
> >
> > Leaving the valuemember blank seems to work for normal listboxes, but
> > for some reason I can't seem to get it going in the grid.
> >
> > I'll have a mess about for 5 mins, give up and try an infragistics
> grid.
> >
> > > -----Original Message-----
> > > From: Discussion of advanced .NET topics. [mailto:ADVANCED-
> > > [EMAIL PROTECTED] On Behalf Of Frans Bouma
> > > Sent: 05 September 2008 14:54
> > > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
> > > Subject: Re: [ADVANCED-DOTNET] DataGridViewComboBoxColumn and entity
> > > framework....
> > >
> > > > In fact saying that I can't (out of the box) get a
> > DataGridViewTextCell
> > > > to work correctly either, it displays the class name...i.e. the
> > default
> > > > ToString()....and there is no option to set which property to
> > display.
> > >
> > > I think your prob is caused by the fact that the EF doesn't
> > have
> > > the
> > > concept of a foreign key field in an entity.
> > >
> > > So say we bind northwind Orders to a datagridview and want
> to
> > pick
> > > the
> > > employees by a combobox in the employee column, you should have a
> > column
> > > of
> > > the 'Employee' present in the grid, and the combobox column should
> > have
> > > its
> > > valuemember left empty. At least that's how it works with 3rd party
> > grids.
> > >
> > > Similar to "Complex databinding example" (selfservicing /
> > adapter)
> > > available here:
> > > http://www.llblgen.com/pages/examples.aspx
> > >
> > > Not for the entity framework, but it shows how it's done.
> When
> > I
> > > hack
> > > around in that example to make it work like you would with the EF, I
> > too
> > > run
> > > into something which I think is a limitation of the datagridview
> > > combobox...:
> > > when I add another column which is bound to Order.Employee (the
> object
> > > property/navigator) and leave valuemember empty, and at runtime
> select
> > a
> > > value
> > > from the combobox, I get a silly text conversion error thrown by the
> > grid
> > > saying that it can't convert a string (the selectedvalue in the
> > combobox)
> > > to
> > > an employee object... Duh... THough it should pick the
> selectedITEM...
> > :/
> > >
> > > devexpress' grid does this properly though. Not sure if you
> > have
> > > that
> > > one available to you.
> > >
> > > So if you pick a real grid, perhaps it works then.
> > >
> > > FB
> > >
> > > >
> > > > Irratatingly I can't find any entity frameworks samples that I can
> > > > download...even when I follow the link on the MS web site, the
> > sample
> > > > code does not exist where they claim it does.
> > > >
> > > >
> > > > > -----Original Message-----
> > > > > From: Discussion of advanced .NET topics. [mailto:ADVANCED-
> > > > > [EMAIL PROTECTED] On Behalf Of Nicholls, Mark
> > > > > Sent: 05 September 2008 13:26
> > > > > To: ADVANCED-DOTNET@DISCUSS.DEVELOP.COM
> > > > > Subject: [ADVANCED-DOTNET] DataGridViewComboBoxColumn and entity
> > > > > framework....
> > > > >
> > > > > Has anyone got this to work?
> > > > >
> > > > > DataGridView are unpleasant things that don't tell you what the
> > > > problem
> > > > > is...
> > > > >
> > > > > I've used the Microsoft Course Sample, and ammended the
> Department
> > > > field
> > > > > to be a DataGridViewComboBoxColumn...
> > > > >
> > > > > bind it to a Department binding source.
> > > > >
> > > > > I'm then given a Display member...which is fine...Name.
> > > > >
> > > > > Then the value member.....ahhh....Department doesn't seem to be
> in
> > the
> > > > > list....and if I use DepartmentID it gets upset....probably
> quite
> > > > > sensibly.
> > > > >
> > > > > Any ideas....?
> > > > >
> > > > > ===================================
> > > > > This list is hosted by DevelopMentor(r) http://www.develop.com
> > > > >
> > > > > View archives and manage your subscription(s) at
> > > > > http://discuss.develop.com
> > > >
> > > >
> > > >
> > > > CONFIDENTIALITY NOTICE
> > > >
> > > > This e-mail (and any attached files) is confidential and protected
> > by
> > > > copyright (and other intellectual property rights). If you are not
> > the
> > > > intended recipient please e-mail the sender and then delete the
> > email
> > > and
> > > > any attached files immediately. Any further use or dissemination
> is
> > > > prohibited.
> > > >
> > > > While MTV Networks Europe has taken steps to ensure that this
> email
> > and
> > > > any attachments are virus free, it is your responsibility to
> ensure
> > that
> > > > this message and any attachments are virus free and do not affect
> > your
> > > > systems / data.
> > > >
> > > > Communicating by email is not 100% secure and carries risks such
> as
> > > delay,
> > > > data corruption, non-delivery, wrongful interception and
> > unauthorised
> > > > amendment. If you communicate with us by e-mail, you acknowledge
> and
> > > > assume these risks, and you agree to take appropriate measures to
> > > minimise
> > > > these risks when e-mailing us.
> > > >
> > > > MTV Networks International, MTV Networks UK & Ireland, Greenhouse,
> > > > Nickelodeon Viacom Consumer Products, VBSi, Viacom Brand Solutions
> > > > International and Comedy Central are all trading names of MTV
> > Networks
> > > > Europe. MTV Networks Europe is a partnership between MTV Networks
> > > Europe
> > > > Inc. and Viacom Networks Europe Inc. Address for service in Great
> > > Britain
> > > > is UK House, 180 Oxford Street, London W1D 1DS, UK.
> > > >
> > > > ===================================
> > > > This list is hosted by DevelopMentor. http://www.develop.com
> > > >
> > > > View archives and manage your subscription(s) at
> > > http://discuss.develop.com
> > >
> > > ===================================
> > > This list is hosted by DevelopMentor(r) http://www.develop.com
> > >
> > > View archives and manage your subscription(s) at
> > > http://discuss.develop.com
> >
> >
> >
> > CONFIDENTIALITY NOTICE
> >
> > This e-mail (and any attached files) is confidential and protected by
> > copyright (and other intellectual property rights). If you are not the
> > intended recipient please e-mail the sender and then delete the email
> and
> > any attached files immediately. Any further use or dissemination is
> > prohibited.
> >
> > While MTV Networks Europe has taken steps to ensure that this email
> and
> > any attachments are virus free, it is your responsibility to ensure
> that
> > this message and any attachments are virus free and do not affect your
> > systems / data.
> >
> > Communicating by email is not 100% secure and carries risks such as
> delay,
> > data corruption, non-delivery, wrongful interception and unauthorised
> > amendment. If you communicate with us by e-mail, you acknowledge and
> > assume these risks, and you agree to take appropriate measures to
> minimise
> > these risks when e-mailing us.
> >
> > MTV Networks International, MTV Networks UK & Ireland, Greenhouse,
> > Nickelodeon Viacom Consumer Products, VBSi, Viacom Brand Solutions
> > International and Comedy Central are all trading names of MTV Networks
> > Europe. MTV Networks Europe is a partnership between MTV Networks
> Europe
> > Inc. and Viacom Networks Europe Inc. Address for service in Great
> Britain
> > is UK House, 180 Oxford Street, London W1D 1DS, UK.
> >
> > ===================================
> > This list is hosted by DevelopMentor(r) http://www.develop.com
> >
> > View archives and manage your subscription(s) at
> > http://discuss.develop.com
>
>
>
> CONFIDENTIALITY NOTICE
>
> This e-mail (and any attached files) is confidential and protected by
> copyright (and other intellectual property rights). If you are not the
> intended recipient please e-mail the sender and then delete the email and
> any attached files immediately. Any further use or dissemination is
> prohibited.
>
> While MTV Networks Europe has taken steps to ensure that this email and
> any attachments are virus free, it is your responsibility to ensure that
> this message and any attachments are virus free and do not affect your
> systems / data.
>
> Communicating by email is not 100% secure and carries risks such as delay,
> data corruption, non-delivery, wrongful interception and unauthorised
> amendment. If you communicate with us by e-mail, you acknowledge and
> assume these risks, and you agree to take appropriate measures to minimise
> these risks when e-mailing us.
>
> MTV Networks International, MTV Networks UK & Ireland, Greenhouse,
> Nickelodeon Viacom Consumer Products, VBSi, Viacom Brand Solutions
> International and Comedy Central are all trading names of MTV Networks
> Europe. MTV Networks Europe is a partnership between MTV Networks Europe
> Inc. and Viacom Networks Europe Inc. Address for service in Great Britain
> is UK House, 180 Oxford Street, London W1D 1DS, UK.
>
> ===================================
> This list is hosted by DevelopMentor. http://www.develop.com
>
> View archives and manage your subscription(s) at http://discuss.develop.com
===================================
This list is hosted by DevelopMentor® http://www.develop.com
View archives and manage your subscription(s) at http://discuss.develop.com
