I am getting an error while I am trying to add data source manually through C#:
An error has occurred during report processing. Cannot create a data reader for dataset 'DataSet1'
My C# Code is:
public DataTable GetData()
{
DataTable dt = new DataTable();
string conString = ConfigurationManager.ConnectionStrings["DatabaseManagerCS"].ConnectionString;
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlDataAdapter sda = new SqlDataAdapter("select ApplicationID,Companyid from Applications", con))
{
sda.Fill(dt);
}
}
return dt;
}
}
protected void Page_Load(object sender, EventArgs e)
{
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.ReportPath = Server.MapPath("~/Report2.rdlc");
ReportDataSource datasource = new ReportDataSource("Dataset1", GetData());
ReportViewer1.LocalReport.DataSources.Add(datasource);
ReportViewer1.LocalReport.Refresh();
}