Gridview Bind with relationship

Posts   
 
    
Posts: 97
Joined: 29-Apr-2009
# Posted on: 18-Aug-2009 05:48:49   

Hello,

i am using LLBLGen 2.6 & self servicing & my database is MS SQL Server 2005

i have two table One is : Holiday & Second is : Market

in Holiday Table i have following fields HolidayID SymID(PK) Holiday Dt TrdType

In Market Table, i have following fields

MarketID(PK) SymID(FK) PWSym Name GroupName Type Sector Exchange ExecType Country

now i can bind data in gridview from table Makrket, so i can get all data of Market Table, but i want to also one more field Holiday from Holiday Table, so it will display Holiday name based on SymID.

i dont want to use row databoound event in gridview, is there any other way to do this thing?

daelmo avatar
daelmo
Support Team
Posts: 8245
Joined: 28-Nov-2005
# Posted on: 18-Aug-2009 07:14:48   
David Elizondo | LLBLGen Support Team
Posts: 97
Joined: 29-Apr-2009
# Posted on: 18-Aug-2009 07:50:17   

daelmo wrote:

Related thread: http://www.llblgen.com/tinyforum/Messages.aspx?ThreadID=14749

i cant understand that thread, can u please provide some sample code please?

Walaa avatar
Walaa
Support Team
Posts: 14993
Joined: 21-Aug-2005
# Posted on: 18-Aug-2009 09:59:50