orginfo.cs

Visual C#.NET数据库开发经典案例解析,这里有1到3的案例

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

namespace 人力资源管理系统
{
	/// <summary>
	/// OrgInfo 的摘要说明。
	/// </summary>
	public class OrgInfo : System.Windows.Forms.Form
	{
		private System.Windows.Forms.DataGrid dataGrid1;
		private System.Windows.Forms.ToolBar toolBar1;
		private System.Windows.Forms.ToolBarButton tbarBtnSave;
		private System.Windows.Forms.ImageList imageList1;
		private System.Data.SqlClient.SqlDataAdapter sqlDataAdapter1;
		private System.Windows.Forms.DataGridTableStyle dataGridTableStyle1;
		private System.Windows.Forms.DataGridTextBoxColumn 单位地址;
		private System.Windows.Forms.DataGridTextBoxColumn 单位电话号码;
		private System.Windows.Forms.DataGridTextBoxColumn 开户银行;
		private System.Windows.Forms.DataGridTextBoxColumn 帐号;
		private System.Windows.Forms.DataGridTextBoxColumn 开户全称;
		private 人力资源管理系统.DataSet1 dataSet11;
		private System.Windows.Forms.DataGridTextBoxColumn 单位名称;
		private System.Windows.Forms.DataGridTextBoxColumn 拼音编码;
		private System.Windows.Forms.ToolBarButton toolBarQuit;
		private System.Data.SqlClient.SqlConnection sqlConnection1;
		private System.Data.SqlClient.SqlCommand sqlSelectCommand1;
		private System.Data.SqlClient.SqlCommand sqlInsertCommand1;
		private System.Data.SqlClient.SqlCommand sqlUpdateCommand1;
		private System.Data.SqlClient.SqlCommand sqlDeleteCommand1;
		private System.ComponentModel.IContainer components;

		public OrgInfo()
		{
			//
			// 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.components = new System.ComponentModel.Container();
			System.Resources.ResourceManager resources = new System.Resources.ResourceManager(typeof(OrgInfo));
			this.dataGrid1 = new System.Windows.Forms.DataGrid();
			this.dataSet11 = new 人力资源管理系统.DataSet1();
			this.dataGridTableStyle1 = new System.Windows.Forms.DataGridTableStyle();
			this.单位名称 = new System.Windows.Forms.DataGridTextBoxColumn();
			this.拼音编码 = new System.Windows.Forms.DataGridTextBoxColumn();
			this.单位地址 = new System.Windows.Forms.DataGridTextBoxColumn();
			this.单位电话号码 = new System.Windows.Forms.DataGridTextBoxColumn();
			this.开户银行 = new System.Windows.Forms.DataGridTextBoxColumn();
			this.帐号 = new System.Windows.Forms.DataGridTextBoxColumn();
			this.开户全称 = new System.Windows.Forms.DataGridTextBoxColumn();
			this.toolBar1 = new System.Windows.Forms.ToolBar();
			this.tbarBtnSave = new System.Windows.Forms.ToolBarButton();
			this.toolBarQuit = new System.Windows.Forms.ToolBarButton();
			this.imageList1 = new System.Windows.Forms.ImageList(this.components);
			this.sqlDataAdapter1 = new System.Data.SqlClient.SqlDataAdapter();
			this.sqlDeleteCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlConnection1 = new System.Data.SqlClient.SqlConnection();
			this.sqlInsertCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlSelectCommand1 = new System.Data.SqlClient.SqlCommand();
			this.sqlUpdateCommand1 = new System.Data.SqlClient.SqlCommand();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
			this.SuspendLayout();
			// 
			// dataGrid1
			// 
			this.dataGrid1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom) 
				| System.Windows.Forms.AnchorStyles.Left) 
				| System.Windows.Forms.AnchorStyles.Right)));
			this.dataGrid1.CaptionVisible = false;
			this.dataGrid1.DataMember = "组织机构编码表";
			this.dataGrid1.DataSource = this.dataSet11;
			this.dataGrid1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGrid1.Location = new System.Drawing.Point(0, 40);
			this.dataGrid1.Name = "dataGrid1";
			this.dataGrid1.Size = new System.Drawing.Size(568, 360);
			this.dataGrid1.TabIndex = 0;
			this.dataGrid1.TableStyles.AddRange(new System.Windows.Forms.DataGridTableStyle[] {
																								  this.dataGridTableStyle1});
			// 
			// dataSet11
			// 
			this.dataSet11.DataSetName = "DataSet1";
			this.dataSet11.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// dataGridTableStyle1
			// 
			this.dataGridTableStyle1.AllowSorting = false;
			this.dataGridTableStyle1.AlternatingBackColor = System.Drawing.Color.LightGray;
			this.dataGridTableStyle1.DataGrid = this.dataGrid1;
			this.dataGridTableStyle1.GridColumnStyles.AddRange(new System.Windows.Forms.DataGridColumnStyle[] {
																												  this.单位名称,
																												  this.拼音编码,
																												  this.单位地址,
																												  this.单位电话号码,
																												  this.开户银行,
																												  this.帐号,
																												  this.开户全称});
			this.dataGridTableStyle1.HeaderForeColor = System.Drawing.SystemColors.ControlText;
			this.dataGridTableStyle1.MappingName = "组织机构编码表";
			// 
			// 单位名称
			// 
			this.单位名称.Format = "";
			this.单位名称.FormatInfo = null;
			this.单位名称.HeaderText = "单位名称";
			this.单位名称.MappingName = "单位名称";
			this.单位名称.NullText = "";
			this.单位名称.Width = 75;
			// 
			// 拼音编码
			// 
			this.拼音编码.Format = "";
			this.拼音编码.FormatInfo = null;
			this.拼音编码.HeaderText = "拼音编码";
			this.拼音编码.MappingName = "拼音编码";
			this.拼音编码.NullText = "";
			this.拼音编码.Width = 75;
			// 
			// 单位地址
			// 
			this.单位地址.Format = "";
			this.单位地址.FormatInfo = null;
			this.单位地址.HeaderText = "单位地址";
			this.单位地址.MappingName = "单位地址";
			this.单位地址.NullText = "";
			this.单位地址.Width = 75;
			// 
			// 单位电话号码
			// 
			this.单位电话号码.Format = "";
			this.单位电话号码.FormatInfo = null;
			this.单位电话号码.HeaderText = "单位电话号码";
			this.单位电话号码.MappingName = "单位电话号码";
			this.单位电话号码.NullText = "";
			this.单位电话号码.Width = 75;
			// 
			// 开户银行
			// 
			this.开户银行.Format = "";
			this.开户银行.FormatInfo = null;
			this.开户银行.HeaderText = "开户银行";
			this.开户银行.MappingName = "开户银行";
			this.开户银行.NullText = "";
			this.开户银行.Width = 75;
			// 
			// 帐号
			// 
			this.帐号.Format = "";
			this.帐号.FormatInfo = null;