• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Merging datasets

Merging datasets

Merging datasets

Rate Merging datasets

• 1
• 2
• 3
• 4
• 5

(1(1 Vote))

        '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")