CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2006
    Posts
    197

    Fill Datagridview alternating data from 2 queries

    I have a Datagridview, It will have pairs of lines:
    first line: requested customer
    second line: assigned quantity for that item for that customer

    Something like:
    CUSTOMER-ITEM-VARIATION1-VARIATION2-VARIATION3-VARIATION4
    Cust001....-120.-......10........-.........0.......-........8........-.........1
    Cust001....-120.-........0........-.........0.......-........0........-.........0
    Cust002....-120.-......15........-.........7.......-........2........-.........0
    Cust002....-120.-........6........-.........0.......-........1........-.........0

    The second line will have numbers if other table has information about that customer reservations, or will be in 0 if not.

    I can load the first line of each pair, with the data of the "requested" items loading a datagrid with a datatable.
    The problem is that i don't know how to add the second line.
    Thanks!
    And sorry if something is hard to understand, english is not my first languaje.
    Last edited by RH+; June 16th, 2010 at 09:36 PM.

  2. #2
    Join Date
    Jan 2006
    Posts
    197

    Re: Fill Datagridview intercalating data from 2 queries

    Sorry for the bump, first and last time...I'm stuck with this =/
    thanks!

  3. #3
    Join Date
    Jan 2006
    Location
    Fox Lake, IL
    Posts
    15,007

    Re: Fill Datagridview intercalating data from 2 queries

    Pretty hard to do, unless you load each row by hand.

    Why not have two grids. When they click on a record on top, the detail records show up on the bottom?
    David

    CodeGuru Article: Bound Controls are Evil-VB6
    2013 Samples: MS CODE Samples

    CodeGuru Reviewer
    2006 Dell CSP
    2006, 2007 & 2008 MVP Visual Basic
    If your question has been answered satisfactorily, and it has been helpful, then, please, Rate this Post!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured