CODEWITHSUNDEEP
c#.netdatatablereportviewer
seeker
seeker

Reputation: 3333

Datatable as datasource in ReportViewer

I want the table component in reportviewer control to be filled in with data from datatable. In other words, i want to use datatable as source for reportviewer control. I tried to create dataset, added datatable with exact columns that my datatable will have after programmatical fill in. Then I used the following code:

 DataTable dt = new DataTable();
 dt.TableName = "DataTable1";
 conn.Open();
 adapter.Fill(dt);
 ReportViewer1.ProcessingMode=ProcessingMode.Local;
 ReportDataSource source = new ReportDataSource("SampleDs", dt);
 ReportViewer1.LocalReport.DataSources.Clear();
 ReportViewer1.LocalReport.DataSources.Add(source);
 ReportViewer1.DataBind();
 ReportViewer1.LocalReport.Refresh();

However, that does not work. The only message I get is:

An error has occurred during report processing. SampleDs.

Can anyone tell me how to solve issue or point out to the refference where full process of creating such report described,

Upvotes: 1

Views: 25079

Answers (1)

Jay Riggs
Jay Riggs

Reputation: 53603

The overload you're using for the constructor of the ReportDataSource object is expecting the name of the data source in that first parameter. You're not supplying this, you need the DataTable name.

Update your code to this and you should be OK:

ReportDataSource source = new ReportDataSource("DataTable1", dt);

Upvotes: 2

Related Questions