水晶报表的操作

				using System;
				using System.Drawing;
				using System.Collections;
				using System.ComponentModel;
				using System.Windows.Forms;
				using System.Data;
				using System.Data.SqlClient;
				
				namespace 主从报表
				{
					/// 
					/// Form1 的摘要说明。
					/// 
					public class Form1 : System.Windows.Forms.Form
					{
						private CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer1;
						/// 
						/// 必需的设计器变量。
						/// 
						private System.ComponentModel.Container components = null;
				
						public Form1()
						{
							//
							// Windows 窗体设计器支持所必需的
							//
							InitializeComponent();
				
							//
							// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
							//
							SqlDataAdapter adapter = new SqlDataAdapter();
							SqlCommand command = new SqlCommand();
							SqlConnection connection = new SqlConnection();
							Dataset1 ds = new Dataset1();
							CrystalReport1 crp = new CrystalReport1();
				
							adapter.SelectCommand = command;
							connection.ConnectionString = "workstation id=localhost;packet size=4096;integrated security=SSPI;initial catalog=NorthWind;persist security info=False";
							command.Connection = connection;
							connection.Open();
							command.CommandText = "SELECT * FROM Orders";
							adapter.Fill(ds,"Orders");
				
							command.CommandText = "SELECT * FROM [Order Details]";
							adapter.Fill(ds,"Order Details");
				
							crp.SetDataSource(ds);
							crystalReportViewer1.ReportSource = crp;
							connection.Close();
						}
				
						/// 
						/// 清理所有正在使用的资源。
						/// 
						protected override void Dispose( bool disposing )
						{
							if( disposing )
							{
								if (components != null) 
								{
									components.Dispose();
								}
							}
							base.Dispose( disposing );
						}
				
						#region Windows 窗体设计器生成的代码
						/// 
						/// 设计器支持所需的方法 - 不要使用代码编辑器修改
						/// 此方法的内容。
						/// 
						private void InitializeComponent()
						{
							this.crystalReportViewer1 = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
							this.SuspendLayout();
							// 
							// crystalReportViewer1
							// 
							this.crystalReportViewer1.ActiveViewIndex = -1;
							this.crystalReportViewer1.Dock = System.Windows.Forms.DockStyle.Fill;
							this.crystalReportViewer1.Location = new System.Drawing.Point(0, 0);
							this.crystalReportViewer1.Name = "crystalReportViewer1";
							this.crystalReportViewer1.ReportSource = null;
							this.crystalReportViewer1.Size = new System.Drawing.Size(292, 266);
							this.crystalReportViewer1.TabIndex = 0;
							// 
							// Form1
							// 
							this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
							this.ClientSize = new System.Drawing.Size(292, 266);
							this.Controls.Add(this.crystalReportViewer1);
							this.Name = "Form1";
							this.Text = "Form1";
							this.WindowState = System.Windows.Forms.FormWindowState.Maximized;
							this.ResumeLayout(false);
				
						}
						#endregion
				
						/// 
						/// 应用程序的主入口点。
						/// 
						[STAThread]
						static void Main() 
						{
							Application.Run(new Form1());
						}
					}
				}