Torna al Thread

Dim strProvider As String = "Provider = Microsoft.Jet.OLEDB.4.0;" Dim NomePerc As String = CStr(Me.txtNomePerc.Text) Dim strOrigine As String = "Data Source=" & Application.StartupPath & "\dbTemp\dbTEMP.mdb" Dim strConnessione As String = strProvider & strOrigine Dim Conn As OleDb.OleDbConnection Conn = New OleDb.OleDbConnection(strConnessione) 'Carica la tabella articoli per il report' Dim cmdArt As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Articoli", strConnessione) Dim objTable As New DataTable() cmdArt.Fill(objTable) 'Carica la tabella cliente per il report' Dim cmdCliente As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Cliente", strConnessione) Dim objTableScadImp As New DataTable() cmdScadImp.Fill(objTableScadImp) 'Carica la tabella trasporto per il report' Dim cmdTrasp As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM Trasporto", strConnessione) Dim objTableTrasp As New DataTable() cmdTrasp.Fill(objTableTrasp) 'Carica la tabella Note per il report' Dim cmdNote As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("SELECT * FROM NoteDoc", strConnessione) Dim objTableNote As New DataTable() cmdNote.Fill(objTableNote) Dim RepPath As String = Application.StartupPath & "\dbTemp\FT2.rpt" Dim Report As New CrystalDecisions.CrystalReports.Engine.ReportDocument() 'Report.Refresh() Report.Load(RepPath) Report.SetDataSource(objTable) 'Alimentazione del report con le tabelle caricate' Report.Database.Tables("Articoli").SetDataSource(objTable) Report.Database.Tables("Cliente").SetDataSource(objTableCliente) Report.Database.Tables("ScadImp").SetDataSource(objTableScadImp) Report.Database.Tables("Trasporto").SetDataSource(objTableTrasp) Report.Database.Tables("NoteDoc").SetDataSource(objTableNote) Me.CrystalReportViewer2.ReportSource = Report
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5