frmzdbp.cs

一个酒店管理系统

using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;

namespace bggl.fm
{
	/// <summary>
	/// frmzdbp 的摘要说明。
	/// </summary>
	public class frmzdbp : System.Windows.Forms.Form
	{
		private bgzdCrystalReport objreport;
		private SqlConnection objcon;
		private SqlDataAdapter objada;
		private DataSet objset;
		private CrystalDecisions.Windows.Forms.CrystalReportViewer crystalReportViewer2;
		/// <summary>
		/// 必需的设计器变量。
		/// </summary>
		private System.ComponentModel.Container components = null;

		public frmzdbp()
		{
			//
			// Windows 窗体设计器支持所必需的
			//
			InitializeComponent();

			//
			// TODO: 在 InitializeComponent 调用后添加任何构造函数代码
			//
		}

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )
			{
				if(components != null)
				{
					components.Dispose();
				}
			}
			base.Dispose( disposing );
		}

		#region Windows 窗体设计器生成的代码
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.crystalReportViewer2 = new CrystalDecisions.Windows.Forms.CrystalReportViewer();
			this.SuspendLayout();
			// 
			// crystalReportViewer2
			// 
			this.crystalReportViewer2.ActiveViewIndex = -1;
			this.crystalReportViewer2.Location = new System.Drawing.Point(0, 0);
			this.crystalReportViewer2.Name = "crystalReportViewer2";
			this.crystalReportViewer2.ReportSource = null;
			this.crystalReportViewer2.Size = new System.Drawing.Size(952, 648);
			this.crystalReportViewer2.TabIndex = 0;
			// 
			// frmzdbp
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(952, 645);
			this.Controls.Add(this.crystalReportViewer2);
			this.Name = "frmzdbp";
			this.Text = "帐单报表浏览";
			this.Load += new System.EventHandler(this.frmzdbp_Load);
			this.ResumeLayout(false);

		}
		#endregion

		private void frmzdbp_Load(object sender, System.EventArgs e)  //水晶报表
		{
		   objreport=new bgzdCrystalReport();
		   objcon=new SqlConnection("server=(local);uid=sa;database=T18_04");
			objada=new SqlDataAdapter("select * from BG_ZD",objcon);

			objset=new DataSet();
			objada.Fill(objset,"BG_ZD");
			objreport.SetDataSource(objset);
			crystalReportViewer2.ReportSource=objreport;
		}
	}
}