default.aspx.cs

csharp课本的源代码

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

using System.Data.SqlClient;
using CrystalDecisions.CrystalReports.Engine;
using CrystalDecisions.Shared;

public partial class _Default : System.Web.UI.Page 
{

    protected void CrystalReportViewer1_Init(object sender, EventArgs e)
    {
        //设置初始缩放比例为75%
        CrystalReportViewer1.Zoom(75);
    }

    protected void Page_Load(object sender, EventArgs e)
    {
        DataSet dataSet = null;
        //检查是否已经缓存
        if (Cache["dataSet"] == null)
        {
            //填充数据集
            dataSet = new DataSet();
            dataSet.ReadXmlSchema(Server.MapPath("XMLSchema.xsd"));
            SqlConnection conn = new SqlConnection(SqlDataSource1.ConnectionString);
            SqlDataAdapter adapter = new SqlDataAdapter(SqlDataSource1.SelectCommand, conn);
            adapter.Fill(dataSet, "MyTable2");
            Cache["dataSet"] = dataSet;
        }
        else
        {
            dataSet = (DataSet)Cache["dataSet"];
        }
        //设置报表源
        ReportDocument reportDocument = new ReportDocument();
        reportDocument.Load(Server.MapPath("MyTable2Report.rpt"));
        reportDocument.SetDataSource(dataSet);
        CrystalReportViewer1.ReportSource = reportDocument;
        //设置报表标题
        reportDocument.SummaryInfo.ReportTitle = "学生基本情况表";
    }
}