version 1.0.2005.1 final (self-servicing)
VS2005 asp.net 2.0
hiya,
This is quite difficult to explain.
I'm binding a typedList to a grid. (telerik)
The grid groups the entities.
It works absolutely fine when I'm binding 1:1
The typedList displays all the pups that are born to a specific dog.
dogName dateOfBirth fatherName motherName
eg
tblDog
dogId PK
fatherId FK (self-referencing to tblDog)
colourId FK
dogName
tblColour
colourId
colourName
My issue.
I have to also display the "colour" of the dog.
I tried to simply add the tblColour entity to the typedList.
The issue is that the predicate takes the ID of the father dog.
The grid therefore displays the colour of the FATHER dog in every row, instead of displaying the respective colour of each pup.
I hope I have explained properly.
What I want the typedList to do is:
Select c.colourName
From tblColour
where fatherId =
Rather than:
Select c.colourName
From tblColour
where dogId =
Can this be done?
I'm struggling.
many thanks,
yogi