merging multiple datasets to bind to a grid

Discussion in 'ASP .Net Datagrid Control' started by Rock, Nov 19, 2004.

  1. Rock

    Rock Guest

    How can I merge 2 datasets into one, then bind with the datagrid, or bind
    the datagrid to 2 datasets? For instance, I have one stored procedure that
    finds company name, address, etc., and another stored procedure that finds
    employees of that company and the employee information.

    Thanks.
     
    Rock, Nov 19, 2004
    #1
    1. Advertising

  2. Couple ways of doing this, you can call merge on the tables in question or
    you can build a new dataset from both datasets by iterating both. If you
    choose the latter, as you iterate and add, you need to remove so that you
    don't have duplicates on the second pass.

    --
    Regards,
    Alvin Bruney
    [ASP.NET MVP http://mvp.support.microsoft.com/default.aspx]
    Got tidbits? Get it here... http://tinyurl.com/27cok
    "Rock" <> wrote in message
    news:...
    > How can I merge 2 datasets into one, then bind with the datagrid, or bind
    > the datagrid to 2 datasets? For instance, I have one stored procedure
    > that
    > finds company name, address, etc., and another stored procedure that finds
    > employees of that company and the employee information.
    >
    > Thanks.
    >
    >
     
    Alvin Bruney [MVP], Nov 19, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Dan Cooper

    Merging datasets

    Dan Cooper, Jan 27, 2004, in forum: ASP .Net
    Replies:
    2
    Views:
    2,339
    Marshal Antony
    Jan 28, 2004
  2. .Net Sports

    Merging datasets for datagrid not working

    .Net Sports, Jul 22, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    355
    .Net Sports
    Jul 22, 2005
  3. news.microsoft.com
    Replies:
    0
    Views:
    440
    news.microsoft.com
    Apr 12, 2006
  4. Francisco Garcia
    Replies:
    2
    Views:
    471
    Fran Garcia
    Apr 13, 2006
  5. .Net Sports

    Merging datasets for datagrid not working

    .Net Sports, Jul 22, 2005, in forum: ASP .Net Web Controls
    Replies:
    0
    Views:
    96
    .Net Sports
    Jul 22, 2005
Loading...

Share This Page