Getting to grips with Crystal

[Jerry Spence1]

I have a Crystal report within VB.Net. I have defined some fields using the
Field Explorer (which is where I think I am going wrong)

I have the following code:

Private Sub Form1_Load(ByVa l sender As System.Object, ByVal e As
System.EventArg s) Handles MyBase.Load
Dim cn As New OleDbConnection
Dim cmd As New OleDbCommand
Dim myDA As New OleDbDataAdapte r
Dim myDS As New Dataset1
Dim rpt As New CrystalReport1
cn.ConnectionSt ring = "Provider=Micro soft.Jet.OLEDB. 4.0;Data
Source=" & MyDatabase
cn.Open()

cmd.Connection = cn
cmd.CommandText = "Select * from People where cardNo = '00001'"
cmd.CommandType = CommandType.Tex t
myDA.SelectComm and = cmd
myDA.Fill(myDS, "People")
rpt.SetDataSour ce(myDS)
CRViewer1.Repor tSource = rpt

End Sub

The problem is that the report is not taking any notice of the code at all.
In fact if I comment out the whole lot, the report still runs and gives me
the whole table. I think my error was in dragging fields from the table onto
the form, but I don't know how else to do it. Could someone give me a nudge
in the right direction please?

thanks

- Jerry