public void loadReports()
{
conn.open( );
string strQry="SELECT Empid,Empname,location,Mobile,Pincode,Salary FROM Employee";
DataTable dt = new DataTable();
ReportViewer1.ShowBackButton = true;
ReportViewer1.ShowPrintButton = true;
ReportViewer1.ShowRefreshButton = true;
//string strConn = System.Configuration.ConfigurationManager.AppSettings["ConnectionString"];
SqlDataAdapter adp = new SqlDataAdapter(strQry,conn);
adp.Fill(dt);
this.ReportViewer1.Visible = true;
this.ReportViewer1.LocalReport.ReportPath = "Report1.rdlc";
ReportDataSource RDS = new ReportDataSource();
RDS.Value = SqlData;
this.ReportViewer1.LocalReport.DataSources.Add(RDS);
ReportViewer1.DataBind();
conn.close( );
}
and my Default.aspx code is
<div>
<rsweb:ReportViewer ID="ReportViewer1" runat="server" ProcessingMode="Remote">
<LocalReport ReportPath="Report1.rdlc">
<DataSources>
<rsweb:ReportDataSource DataSourceId="SqlData" />
</DataSources>
</LocalReport>
</rsweb:ReportViewer>
<asp:SqlDataSource ID="SqlData" runat="server"
ConnectionString="<%$ ConnectionStrings:masterConnectionString2 %>"
SelectCommand="SELECT [Empid], [Empname], [location], [Mobile], [Pincode], [Salary] FROM [Employee]">
</asp:SqlDataSource>
</div>
Please try to find errors why i can't able to load reports using the above code. When the above code is run,only white page appears.
Can you answer this question?
Answer
0 Answers