Results 1 to 4 of 4

Thread: [RESOLVED] marge two Dataset to into one dataset

  1. #1

    Thread Starter
    Junior Member
    Join Date
    Nov 2017
    Posts
    25

    Resolved [RESOLVED] marge two Dataset to into one dataset

    Actually i have not tried any Codes yet, what i have tried is to manipulate the dataset but i get Expr1, Expr2 and so on.
    Name:  iiii.jpg
Views: 209
Size:  23.2 KB
    i want to merge the Assessment1 dataset with Assessment2 dataset to get one detaset Assessment.
    any help please

  2. #2
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,299

    Re: marge two Dataset to into one dataset

    They aren't DataSets. They are DataTables in the same DataSet. If they actually correspond to two different tables in your database then what you actually need to do is redesign that database. With the design you have, if you were to add another assessment then that would require adding another table when it should actually only require adding another row to an existing table.

  3. #3

    Thread Starter
    Junior Member
    Join Date
    Nov 2017
    Posts
    25

    Re: marge two Dataset to into one dataset

    thanks for the explanation but is there a way i can merge the two tables into one

  4. #4
    Super Moderator jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    110,299

    Re: marge two Dataset to into one dataset

    No. They are what they are. You can add another DataTable that is generated from a query that creates a union of the data from the two database tables. I can't really recommend that over redesigning the database though.

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