//declare conn string
string connstr =
"Data Source=168.10.11.3;Initial Catalog=RealWorld;Persist Security Info=True;User ID=sa;Password=111111";
//declare conn ,command
SqlConnection conn = new SqlConnection(connstr);
SqlCommand cmd = new SqlCommand();
DataSet ds = new dsReport();
try
{
conn.Open();
cmd.Connection =conn;
cmd.CommandText = "SELECT * FROM AgedAR";
SqlDataReader dr = cmd.ExecuteReader();
ds.Tables[0].Load(dr);
//=============================================
//与winform不同
// ReportViewer1.LocalReport.ReportEmbeddedResource = "Report1.rdlc";
ReportViewer1.LocalReport.ReportPath = "Report1.rdlc";
//Report DataSource
ReportDataSource rds = new ReportDataSource();
rds.Name = "dsReport_dtAgedAR";
rds.Value = ds.Tables[0];
ReportViewer1.LocalReport.DataSources.Add(rds);
}
catch (Exception ex)
{
Response.Write(ex.Message);
}
finally
{
conn.Close();
}
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步