Click here to Skip to main content
12,957,398 members (56,656 online)
Rate this:
 
Please Sign up or sign in to vote.
See more: , +
my problem is i know how to retrive a data from single table and bind it to crystal report and using crystal report viewer i can directly print it using directly button clicking on my form


but i have problem that is how can i retrive a data from more than one table and used it..

for single table the code is as follow:
On Button click event:
Call openconnection()
        str = "SELECT * from New_Case_Id_Master where CaseId=" & s_no & ""
        da = New SqlDataAdapter(str, cn)
        ds.Clear()
 
        da.Fill(ds, "New_Case_Id_Master")
        'MsgBox(ds.Tables("New_Case_Id_Master").Rows.Count)
        cn.Close()
        'print directly using button click
        Dim objRpt As New CrystalReport_for_FrontDesk
        objRpt.SetDataSource(ds.Tables("New_Case_Id_Master"))
        CrystalReportViewer1.ReportSource = objRpt
        CrystalReportViewer1.PrintReport()
        CrystalReportViewer1.PrintReport()
        CrystalReportViewer1.Refresh()
 


my question is how can i modify this code for retrieving data from multiple tables..
Posted 20-Sep-12 4:09am
Comments
Wes Aday 20-Sep-12 10:18am
   
You create a query to get the information from the tables that you want.... so change your str variable to your new query. Then research "parameterized queries" and "sql injection attacks".

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

    Print Answers RSS
Top Experts
Last 24hrsThis month
OriginalGriff 6,994
CHill60 3,550
Maciej Los 3,312
ppolymorphe 2,170
Jochen Arndt 1,973


Advertise | Privacy | Mobile
Web02 | 2.8.170525.1 | Last Updated 24 Sep 2012
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100