Jobs
Author: ajith chandran Date Submitted: 9/29/2006 Category: Database Compatibility: This code has been accessed 5522 times.
Email Yourself this snippet:
No declarations
Code
'Dim adptHeader As New SqlDataAdapter '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")
