我这样写对吗?
protected void Page_Load(object sender, EventArgs e)
{
if (IsPostBack)
{
return;
}
GrapeCity.ActiveReports.PageReport report1 = new GrapeCity.ActiveReports.PageReport(new System.IO.FileInfo(Server.MapPath("PageReport1.rdlx")));
report1.Document.LocateDataSource += new GrapeCity.ActiveReports.LocateDataSourceEventHandler(WebViewer1_LocateDataSource1);
WebViewer1.PdfExportOptions.FitWindow = false;
WebViewer1.PdfExportOptions.DisplayMode = GrapeCity.ActiveReports.Export.Pdf.Section.DisplayMode.Outlines;
WebViewer1.Report = report1;
}
protected void WebViewer1_LocateDataSource1(object sender, GrapeCity.ActiveReports.LocateDataSourceEventArgs args)
{
if (args.DataSourceName == "DataSource1")
{
if (args.DataSetName == "DataSet1")
{
string strCom = " select top(20)id,borrowId,borrowTitle,borrowMoney,dateline,maxRate,listStatus from tb_borrowInfo order by id asc";
//创建一个 DataSet对象
System.Data.DataSet ds = null;
myConn.Open();
SqlDataAdapter myCommand = new SqlDataAdapter(strCom, myConn);
myCommand.Fill(ds, "tb_borrowInfo");
myConn.Close();
args.Data = ds;
}
}
} |