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
Replies
Peter Jones
Peter Jones
Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)Advanced StrataFrame User (718 reputation)
Group: Forum Members
Posts: 386, Visits: 2.1K
Hi Denis,



Unless I misunderstand you I think this falls into the 'its so simple - why didn't I think of that' category (of which I have had many!).



Create your BO.



Drop it on the form.



Drop a S/Frame BBS onto the form.



Assign the BO as the data source for the BBS.



Go to the properties page for your grid and assign the BBS to the grid's DataSource and you're done.



Cheers, Peter
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