Torna al Thread

Function VisualizzaReport() 'Gestione pulsante visualizza dalla pagina del report Dim ds As New DataSet1() 'Dataset di connessione Dim conn As New OleDb.OleDbConnection() 'Connessione Dim sApp As String 'Stringa d'appoggio Dim Query As String 'Query per comandi sql Dim DaData As String 'Data inizio Dim AData As String 'Data fine Dim myReport = New ATM900s 'Inizializzo un report fittizio Dim PercorsoDB As String 'Percorso database Dim NomeTabella As String 'Nome tabella DaData = CStr(Format(Report.DaDate.Value, "dd/MM/yyyy")) AData = CStr(Format(Report.ADate.Value, "dd/MM/yyyy")) myReport = New ATM900g PercorsoDB = "\\192.168.1.100\d\FTP\Davide\DBase.mdb" NomeTabella = "Tab_ATM900_1" Query = "SELECT * FROM " & NomeTabella & " WHERE Data Between '" & DaData & "' And '" & AData & "'" sApp = "provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & PercorsoDB & ";" conn.ConnectionString = sApp conn.Open() Dim da As New OleDb.OleDbDataAdapter(Query, conn) da.Fill(ds, NomeTabella) myReport.SetDataSource(ds) Report.CrystalReportViewer1.ReportSource = myReport End Function
Copyright © dotNetHell.it 2002-2024
Running on Windows Server 2008 R2 Standard, SQL Server 2012 & ASP.NET 3.5