4,818
社区成员
发帖
与我相关
我的任务
分享
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
this.ReportViewer1.LocalReport.ReportPath = MapPath("AgentDuty.rdlc");
this.ReportViewer1.LocalReport.DataSources.Clear();
DataSet ds = Getdata();
ReportDataSource rd = new ReportDataSource("DataSet1", ds.Tables[0]);
this.ReportViewer1.LocalReport.DataSources.Add(rd);
this.ReportViewer1.LocalReport.Refresh();
}
}
/// <summary>
/// 绑定数据源,返回DataSet类型
/// </summary>
/// <returns></returns>
public DataSet Getdata()
{
string sqlcon = @"server=.;database=RdlcTest;uid=sa;";
string sql = "select top * from Table_Test";
// sql = "select *from RdlcEntity";
using (SqlConnection con = new SqlConnection(sqlcon))
{
con.Open();
SqlDataAdapter da = new SqlDataAdapter(sql, con);
DataSet ds = new DataSet();
da.Fill(ds);
return ds;
}
}