Init

53         public CrystalDecisions.CrystalReports.Engine.Section Section1 {
54             get {
55                 return this.ReportDefinition.Sections[0];
56             }
57         }

61         public CrystalDecisions.CrystalReports.Engine.Section Section2 {
62             get {
63                 return this.ReportDefinition.Sections[1];
64             }
65         }

69         public CrystalDecisions.CrystalReports.Engine.Section Section3 {
70             get {
71                 return this.ReportDefinition.Sections[2];
72             }
73         }

77         public CrystalDecisions.CrystalReports.Engine.Section Section4 {
78             get {
79                 return this.ReportDefinition.Sections[3];
80             }
81         }

85         public CrystalDecisions.CrystalReports.Engine.Section Section5 {
86             get {
87                 return this.ReportDefinition.Sections[4];
88             }
89         }

93         public CrystalDecisions.Shared.IParameterField Parameter_txtMaLop {
94             get {
95                 return this.DataDefinition.ParameterFields[0];
96             }
97         }

14         public Form9()
15         {
16             InitializeComponent();
17         }

18         public FormBaoCao()
19         {
20             InitializeComponent();
21         }

40         private void btnLoc_Click(object sender, EventArgs e)
41         {
42             SqlConnection con = dal.GetConnect();
43             con.Open();
44             string sql = "select *from SinhVien where MaLop=@MaLop";
45             SqlDataAdapter da = new SqlDataAdapter(sql, con);
46             da.SelectCommand.Parameters.AddWithValue("@MaLop", cmbMaLop.SelectedValue.ToString());
47             DataTable dt = new DataTable();
48             da.Fill(dt);
49             crBaoCao cr = new crBaoCao();
50             ConnectionInfo crConnectionInfo = new ConnectionInfo();
51             crConnectionInfo.ServerName = "Ty-PC";
52             crConnectionInfo.DatabaseName = "CNPM_1";
53             crConnectionInfo.UserID = "sa";
54             crConnectionInfo.Password = "04091990";
55             TableLogOnInfos crTableLogonInfos = new TableLogOnInfos();
56             foreach (CrystalDecisions.CrystalReports.Engine.Table table in cr.Database.Tables)
57             {
58                 TableLogOnInfo crTableLogonInfo = new TableLogOnInfo();
59                 crTableLogonInfo.TableName = table.Name;
60                 crTableLogonInfo.ConnectionInfo = crConnectionInfo;
61                 crTableLogonInfos.Add(crTableLogonInfo);
62                 table.ApplyLogOnInfo(crTableLogonInfo);
63
64             }
65             crvHocKyHocPhan.LogOnInfo = crTableLogonInfos;
66             cr.SetDataSource(dt);
67             ParameterValues a = new ParameterValues();
68             ParameterDiscreteValue b = new ParameterDiscreteValue();
69             b.Value = cmbMaLop.SelectedValue.ToString();
70             a.Add(b);
71             cr.DataDefinition.ParameterFields["txtMaLop"].ApplyCurrentValues(a);
72             crvHocKyHocPhan.ReportSource = cr;
73             crvHocKyHocPhan.Show();
74         }

14         public FormDangNhap()
15         {
16             InitializeComponent();
17         }