form1.cs

csharp课本的源代码

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;

namespace ComplicatedReportExample
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
            //设置窗体工作区大小
            this.ClientSize = new Size(750, 530);
            //设置窗体起始位置
            this.StartPosition = FormStartPosition.CenterScreen;
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            //填充数据集
            myTable1TableAdapter1.Fill(myDatabaseDataSet1.MyTable1);
            myTable2TableAdapter1.Fill(myDatabaseDataSet1.MyTable2);
            myTable3TableAdapter1.Fill(myDatabaseDataSet1.MyTable3);
            //设置报表数据来源
            studentReport1.SetDataSource(myDatabaseDataSet1);
            //设置报表标题
            studentReport1.SummaryInfo.ReportTitle = "学生情况表";
            //触发radioButton_CheckedChanged事件
            radioButtonAll.Checked = true;
        }

        private void radioButton_CheckedChanged(object sender, EventArgs e)
        {
            RadioButton radioButton = (RadioButton)sender;
            switch (radioButton.Text)
            {
                case "全部学生":
                    studentReport1.RecordSelectionFormula = "";
                    break;
                case "所有姓名中包含“王”的学生":
                    studentReport1.RecordSelectionFormula = "{MyTable2.姓名} like '*王*'";
                    break;
                case "所有成绩大于等于60的学生":
                    studentReport1.RecordSelectionFormula = "{MyTable2.成绩} >= 60";
                    break;
            }
            //绑定报表
            this.crystalReportViewer1.ReportSource = studentReport1;
            //设置初始缩放比例为76%
            crystalReportViewer1.Zoom(76);
        }
    }
}