Click here to Skip to main content
11,578,524 members (59,272 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: SQL-Server-2008 VB.NET , +
Hi all,

I'm fairly new to programming (been at it for a year now). I'm having some trouble with my program. I use a lot of datagridviews but somethimes it just doesn't cut it (or i don't know how to do it) Smile | :)

My question to all you advanced programmers. I have a table called orders (sql 2008 database) with some fields like: OrderID, Date, OrderedBy,... And then i have another table called Orderlines with the fields as: OrderID, ProductID, Quantity, Amount, Cost, LineNR,...

These twoo relate one to many. So orders is the 'headline' and it has some detailed orderlines. Now i would like to show them in a grid of some sort that users can expand per orderID and so expand the orderlines. Is something like this possible? Any step in the right direction would be grately appreciated.

BTW: i used to have the orders in one grid and then with selection changed i showed the orderlines in another grid.

Thanks in advance (and sorry for my english)!

Greetings
Posted 9-Jul-12 9:49am
Edited 9-Jul-12 9:52am
v2

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

IF this problem is WPF related I would create a ListView that had one filed with an expander in it called Orders. In Windows Forms I dont really know...
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 Peter Leow 135
1 OriginalGriff 113
2 Richard MacCutchan 85
3 Afzaal Ahmad Zeeshan 75
4 Frankie-C 75
0 OriginalGriff 933
1 Sergey Alexandrovich Kryukov 740
2 Abhinav S 573
3 F-ES Sitecore 420
4 Suvendu Shekhar Giri 403


Advertise | Privacy | Mobile
Web03 | 2.8.150603.1 | Last Updated 10 Jul 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100