editing fk in a datagrid

Posts   
 
    
msorondo
User
Posts: 4
Joined: 30-Jul-2004
# Posted on: 30-Jul-2004 21:29:55   

hi everybody i´m evaluating llbl in this days

supose we have two tables Customers and Countries where each customer has only one Country assigned so

Customers

CustomerID CustomerName CountryID

Countries

CountryID CountryName

i chose the selfservicing template and i´m trying to find the easiest way to bound Customers table to a datagrid allowing the user to edit all customers information CHOOSING the country from a combobox or a select list

i read that typedlists are read only so cant use them for this purpose. regards

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 31-Jul-2004 11:33:51   

You can load the countries entities in an entity collection and depending on which grid control you're using, use that list to fill the combo box data that is displayed in the column where you show the countryID of the customer.

Frans Bouma | Lead developer LLBLGen Pro
msorondo
User
Posts: 4
Joined: 30-Jul-2004
# Posted on: 31-Jul-2004 14:24:17   

thanks a lot Otis. i didn't know if it was possible

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 31-Jul-2004 14:49:13   

msorondo wrote:

thanks a lot Otis. i didn't know if it was possible

Well, it depends on which grid you're using if it's easy or not. The .NET grid is a little hard to use in this, but for example the infragistics grid can be easily setup with this.

Frans Bouma | Lead developer LLBLGen Pro
Gabor
User
Posts: 97
Joined: 29-Jan-2005
# Posted on: 31-Jan-2005 07:28:05   

Hi,

Could you tell me, what is an infragistic grid, and where can i obtain them?

Thanks

Gabor

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39933
Joined: 17-Aug-2003
# Posted on: 31-Jan-2005 09:31:30   

The grid control of infragistics simple_smile But I'd go for Janus systems' gridex if I were you.

Frans Bouma | Lead developer LLBLGen Pro
Gabor
User
Posts: 97
Joined: 29-Jan-2005
# Posted on: 31-Jan-2005 09:48:46   

smile smile Thanks