Multitable DataSource in DataGrid using BBS or ?


Author
Message
dgsoft
dgsoft
StrataFrame User (215 reputation)StrataFrame User (215 reputation)StrataFrame User (215 reputation)StrataFrame User (215 reputation)StrataFrame User (215 reputation)StrataFrame User (215 reputation)StrataFrame User (215 reputation)StrataFrame User (215 reputation)StrataFrame User (215 reputation)
Group: StrataFrame Users
Posts: 93, Visits: 236
Hi,

I looking the way to create Grid with multitable content. For example, if dataset contains 2 tables with relation between them, with DevExpress datagrid I can display both tables and expand row of master table to see related records from child table.

This works with DataSet .. but I can't imagine how it works with BusinessObjects and BBS... how to build using BOs this DataSource for the grid.

If you have example, would you be so kind to send it, or maybe any solution for this problem



Thank you

Denis Gavrikov
Reply
dgsoft
dgsoft
StrataFrame User (215 reputation)StrataFrame User (215 reputation)StrataFrame User (215 reputation)StrataFrame User (215 reputation)StrataFrame User (215 reputation)StrataFrame User (215 reputation)StrataFrame User (215 reputation)StrataFrame User (215 reputation)StrataFrame User (215 reputation)
Group: StrataFrame Users
Posts: 93, Visits: 236
Hi,

Ok.. I try to explain the problem.



I have 2 tables. for example Customers and Orders with relation by Customer Id..

Now I want using DevExpress DataGrid display the customer list.. and related orders.

For this purpose in the DevExpress Example they create DataSet, add Customers and Orders Tables into the DataSet.

Add relation Object to dataset

and set the DataSource of DevExpress DataGrid ás DataSet..



Then.. I can see my customers list in the grid with [+] - like as Treeview.. and when I expand row.. I can see the grid with Orders!



Now.. what can I do with BusinessObject.

I create BO based on CUstomers.

Ok.. Made new WinForm.. put CustomersBO to the form,

Add BBS and bind BBS to the DataGrid DataSOurce..

Now I have customers list.



But HOW TO ADD relation and Orders Table to the same grid?



Thanks

Denis
GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search