Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data from two tables(1-to-1) into one grid
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Miscellaneous
Thread ID:
00880610
Message ID:
00884026
Views:
27
Christian,

If you need to show address on the same level as name then it will need to be in the same table for binding. In the select statement used to pull information from the backend, add a join between the two tables and include address in the selected fields. That way you can view the address when binding the table. If you use the CommandBuilder, then when you perform the update, set the UpdateSelectStatement property to the select statement without the address field. That way only the company table be used to generate the statements.

>The example from earlier:
>A Company table has : key | name
>An Address table has : key | address
>
>When I do it like you suggested, I get the "name" and then a "+" that I can click and see "address" in a new record of the grid.
>
>I would like to see: column1 = "name", column2 = "address".
>Isn't that possible?
>Thank you for helping.
>Regards
>Christian Kirschberg
-----------------------------------------

Cathi Gero, CPA
Prenia Software & Consulting Services
Microsoft C# / .NET MVP
Mere Mortals for .NET MVP
cgero@prenia.com
www.prenia.com
Weblog: blogs.prenia.com/cathi
Previous
Reply
Map
View

Click here to load this message in the networking platform