Yet another data source gripe!!

[protechdm]

Hi,

Platform .NET / Access 2000 / Win2000 / CR version whatever-was-in-the-latest-.net-service-pack.

Basically I have one report that suits 2 different tables ( same structure ) in an Access database. So, I added 1 of the tables - GROSSWP - to the report purely for design purposes. It was chosen via OLE DB(ADO) >> database.mdb >> Views >> GROSSWP.

The following code is an attempt to overwrite the data source with a dataset containing a table with exactly the same structure as GROSSWP in a standard windows form with a report viewer:-

query = "select * from cashbord"
Dim conn As String = _
"Provider=Microsoft.Jet.OLEDB.4.0; Data
Source='c:\development\barnsley\data\insite.mdb'"
Dim myoleconn As New
System.Data.OleDb.OleDbConnection(conn)
Dim myoleadapter As New
System.Data.OleDb.OleDbDataAdapter()
Dim mydataset As Data.DataSet = New DataSet()
myoleadapter.SelectCommand = New
System.Data.OleDb.OleDbCommand(query, myoleconn)
myoleadapter.Fill(mydataset, "stndbord&quot

Dim bord As New Old_Summary_Bordereau()
bord.SetDataSource(mydataset)
Me.CrystalReportViewer1.ReportSource = bord
bord.Refresh()

It still gives me the data from GROSSWP.

Any ideas?