pregasi evitare di suggerirmi il sito "gotreportviewer": non ci si capisce niente.
il mio codice è questo:
codice:
su modulo:
Public AccessConn As System.Data.OleDb.OleDbConnection
Public AccessCommand As System.Data.OleDb.OleDbCommand
Public AccessReader As System.Data.OleDb.OleDbDataReader
Public BS_Tab As New BindingSource
Public StrMSG As String, QueryCMD As String
su codice del form:
Dim rds As Microsoft.Reporting.WinForms.ReportDataSource = New Microsoft.Reporting.WinForms.ReportDataSource
QueryCMD = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=c:\pippo\gestv.accdb;Persist Security Info=False;"
AccessConn = New System.Data.OleDb.OleDbConnection(QueryCMD)
AccessConn.Open()
QueryCMD = "SELECT * FROM tblNominativi"
AccessCommand = New System.Data.OleDb.OleDbCommand(QueryCMD, AccessConn)
AccessCommand.CommandType = CommandType.Text
BS_Tab.DataSource = AccessCommand.ExecuteReader(CommandBehavior.CloseConnection)
rds.Name = "gevar.dataset1"
rds.Value = BS_Tab
ReportViewer1.LocalReport.ReportPath = My.Application.Info.DirectoryPath & "\drprubrica.rdlc"
ReportViewer1.LocalReport.ReportEmbeddedResource = My.Application.Info.DirectoryPath & "\drprubrica.rdlc"
ReportViewer1.LocalReport.DataSources.Add(rds)
ReportViewer1.RefreshReport()
AccessConn.Close()
Mi visualizza solo l'intestazione del report, con i nomi delle colonne ma i dati non ci sono.
Non capisco dove sbaglio. ho cercato per 3 ore in rete ma non riesco a trovare l'errore.