Merging datasets

by ajith chandran (1 Submission)
Category: Databases/Data Access/DAO/ADO
Compatability: VB 6.0
Difficulty: Unknown Difficulty
Originally Published: Fri 29^th September 2006
Date Added: Mon 8^th February 2021
Rating: (1 Votes)

Merging datasets

Rate Merging datasets



        'Dim adptDetails As New SqlDataAdapter

        'adptHeader = New SqlDataAdapter("select group_code_id='Ref' ,name ,debit,credit from VIEW_09_TrialBalance_3", DbConnection)
        'adptDetails = New SqlDataAdapter("select group_code_id='Ref',name,trns_date,debit_amount,credit_amount from VIEW_04_DayBook_01", DbConnection)


        'Dim _dataSet As New DataSet
        'adptHeader.Fill(_dataSet, "Header")
        'adptDetails.Fill(_dataSet, "Details")

        '_dataSet.Relations.Add("Details", _dataSet.Tables("Header").Columns("group_code_id"), _dataSet.Tables("Details").Columns("group_code_id"))
        'GrdTrialBalance.SetDataBinding(_dataSet, "Header")

Download this snippet Add to My Saved Code

Merging datasets Comments

No comments have been posted about Merging datasets. Why not be the first to post a comment about Merging datasets.

Merging datasets

Merging datasets Comments

Post your comment

Difficulty