> 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.
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.
> 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-
> > DOTNET@DISC...] On Behalf Of Nicholls, Mark
> > Sent: 05 September 2008 13:26
> > To: ADVANCED-DOTNET@DISC... > > Subject: [ADVANCED-DOTNET] DataGridViewComboBoxColumn and entity
> > framework....
> > Has anyone got this to work?
> > DataGridView are unpleasant things that don't tell you what the
> > is...
> > I've used the Microsoft Course Sample, and ammended the Department
> > 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
> 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