Guest User

Untitled

a guest
Oct 24th, 2016
54
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.09 KB | None | 0 0
  1. Dim data As clsData = clsData.Instance
  2. Dim ds As New DataSet
  3. Dim tblMyCompany As DataTable = data.GetDataTableFromQuery("select * from tblCompany where Id = (select CompId from tblCheckIn Where Id =" & CheckId & ")")
  4. tblMyCompany.TableName = "tblCompany"
  5. ds.Tables.Add(tblMyCompany)
  6. Dim tblCheckIn As DataTable = data.GetDataTableFromQuery("select * from tblCheckIn where id=" & CheckId)
  7. tblCheckIn.TableName = "tblCheckIn"
  8. ds.Tables.Add(tblCheckIn)
  9.  
  10. Dim CheckInRoomQuery As DataTable = data.GetDataTableFromQuery("select * from CheckInRoomQuery where ChId=" & CheckId)
  11. CheckInRoomQuery.TableName = "CheckInRoomQuery"
  12. ds.Tables.Add(CheckInRoomQuery)
  13. Dim tblCheckInExtra As DataTable = data.GetDataTableFromQuery("select * from tblCheckInExtra where ChId=" & CheckId)
  14. tblCheckInExtra.TableName = "tblCheckInExtra"
  15. ds.Tables.Add(tblCheckInExtra)
  16.  
  17. Dim ob As rptCheckOut = New rptCheckOut
  18.  
  19. ob.SetDataSource(ds)
  20.  
  21. ob.Subreports(0).SetDataSource(CheckInRoomQuery)
  22. 'ob.Subreports(1).SetDataSource(tblCheckInExtra)
  23. CrystalReportViewer1.ReportSource = ob
Add Comment
Please, Sign In to add comment