Could someone please explain to me how to do the following. I have the following ADO.NET table created in the report source (shown below). How do I make the data available in a report.
Our company has been creating a DataSet.xsd in the solution and then add a report dataset that is set to the table in the DataSet.xsd. Then we add a ObjectDataSource, set it's DataSource to the DataSet in the report and then bind the report (ie: set the report datasource) to the ObjectDataSource. This will make it's fields available in the report. Note: We load the ObjectDataSource in the report source, ie: DataSet.ObjectDataSource.Load(dtSource). The problem with this method is that it requires you to add a new table for your report to the DataSet.xsd everytime you want to pass something that hasn't already been created to the xsd.
Is there a way to just add a blank dataset to the report, set a ObjectDataSource.DataSource to the dataset and then just load the dataset in the source? ie: Skip the DataSet.xsd part?
dt As New DataTable
Dim row As New DataRow
dt.Columns.Add("Id", GetType(Integer))
dt.Columns.Add("FirstName", GetType(String))
dt.Columns.Add("LastName", GetType(String))
row = dt.NewRow()
row("Id") = 1
row("FirstName") = "John"
row("LastName" = "Smith"
dt.Rows.Add(row)
Thanks in advance.