Hi! I got few questions to ask regarding the ado.net dataset.

1) Can I have more than 1 table views (sql2000) in 1 dataset?
2) How do I make the connection if I have more than 1 table views in my dataset?

eg. (For 1 table views)

        Dim vNric As String
        Dim objReport As New cr_Test() 'Crystal Report
        Dim myDataSet As New DS_Test() 'Dataset1

        SqlStmt = "SELECT * from vIND_Profile where nric_fin = '" & txtID &"'"
        myCmd = New SqlCommand(SqlStmt, sqlConn)
        mySqlAdapter = New SqlDataAdapter(SqlStmt, sqlConn)
        mySqlAdapter.Fill(myDataSet, "vIND_Profile")

        objReport.SetDataSource(myDataSet)
        Me.CrystalReportViewer1.ReportSource = objReport


------------------------

The above only for 1 table views. How to do the codes if I have more than 1 tables?

Thanks.

Regards,

I'm not familiar with crystal reports. When you set the report data source, try this:

objReport.SetDataSource(myDataSet.Tables("vIND_Pro file"))

or:

objReport.SetDataSource(myDataSet.Tables("vIND_Pro file").DefaultView)

Brian