dcsimg
Results 1 to 4 of 4
  1. #1

    Thread Starter
    Junior Member
    Join Date
    Nov 2017
    Posts
    16

    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: 120
Size:  23.2 KB
    i want to merge the Assessment1 dataset with Assessment2 dataset to get one detaset Assessment.
    any help please

  2. #2
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    98,681

    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.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

  3. #3

    Thread Starter
    Junior Member
    Join Date
    Nov 2017
    Posts
    16

    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
    .NUT jmcilhinney's Avatar
    Join Date
    May 2005
    Location
    Sydney, Australia
    Posts
    98,681

    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.
    Why is my data not saved to my database? | MSDN Data Walkthroughs
    VBForums Database Development FAQ
    My CodeBank Submissions: VB | C#
    My Blog: Data Among Multiple Forms (3 parts)
    Beginner Tutorials: VB | C# | SQL

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width


×
We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.