Attach a dataset to a table (MS reporting)

[daviddoria]

I want to do something like this:

        'create a dataset and a table
        Dim ds As New DataSet
        ds.Tables.Add("TestTable")
        ds.Tables("TestTable").Columns.Add("Names", System.Type.GetType("System.String"))

        'create a test row
        Dim TestRow As DataRow = ds.Tables("TestTable").NewRow
        TestRow.Item("Names") = "hello world"

        ds.Tables("TestTable").Rows.Add(TestRow)

        'attach dataset to report
        Dim dsname As String = "Dataset1"
        Dim rs As New Microsoft.Reporting.WinForms.ReportDataSource(dsname, ds.Tables("TestTable"))
        ReportViewer1.LocalReport.DataSources.Add(rs)

        'attach dataset to table on report
        ReportViewer1.LocalReport. '???

However I get this error:

The table ‘table1’ is in the report body but the report has no data set.  Data regions are not allowed in reports without datasets.

There is no way for me to attach the dataset at design time, because it is not yet created! Is there a way around this? Also notice the last line is not complete in the code - how do you actually assign the dataset to the table on the report?

Thanks!

Dave

[daviddoria]

The only thing I could think of was to actually save the table to a database and setup the Table control's query to get the data from that data base. That seems really goofy though if the data is never to be used again, no?

Dave