materialsform.cs

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

			{
				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(MaterialsForm));
			this.da1 = 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();
			this.dataSet11 = new 生产管理系统.DataSet1();
			this.dataGrid1 = new System.Windows.Forms.DataGrid();
			this.dataGridTableStyle1 = new System.Windows.Forms.DataGridTableStyle();
			this.dataGridTextBoxColumn1 = new System.Windows.Forms.DataGridTextBoxColumn();
			this.dataGridTextBoxColumn2 = new System.Windows.Forms.DataGridTextBoxColumn();
			this.groupBox1 = new System.Windows.Forms.GroupBox();
			this.txt2 = new System.Windows.Forms.TextBox();
			this.label1 = new System.Windows.Forms.Label();
			this.btnSearch = new System.Windows.Forms.Button();
			this.txt1 = new System.Windows.Forms.TextBox();
			this.label2 = new System.Windows.Forms.Label();
			this.txt3 = new System.Windows.Forms.TextBox();
			this.label3 = new System.Windows.Forms.Label();
			this.toolBar1 = new System.Windows.Forms.ToolBar();
			this.tBtnFirst = new System.Windows.Forms.ToolBarButton();
			this.tBtnPre = new System.Windows.Forms.ToolBarButton();
			this.tBtnNext = new System.Windows.Forms.ToolBarButton();
			this.tBtnLast = new System.Windows.Forms.ToolBarButton();
			this.tBtnNew = new System.Windows.Forms.ToolBarButton();
			this.tBtnEdit = new System.Windows.Forms.ToolBarButton();
			this.tBtnDelete = new System.Windows.Forms.ToolBarButton();
			this.tBtnSubmit = new System.Windows.Forms.ToolBarButton();
			this.tBtnCancel = new System.Windows.Forms.ToolBarButton();
			this.tBtnQuit = new System.Windows.Forms.ToolBarButton();
			this.imageList1 = new System.Windows.Forms.ImageList(this.components);
			this.groupBox2 = new System.Windows.Forms.GroupBox();
			this.txt12 = new System.Windows.Forms.TextBox();
			this.txt11 = new System.Windows.Forms.TextBox();
			this.txt10 = new System.Windows.Forms.TextBox();
			this.txt13 = new System.Windows.Forms.TextBox();
			this.txt15 = new System.Windows.Forms.TextBox();
			this.txt16 = new System.Windows.Forms.TextBox();
			this.txt14 = new System.Windows.Forms.TextBox();
			this.txt17 = new System.Windows.Forms.TextBox();
			this.txt19 = new System.Windows.Forms.TextBox();
			this.txt18 = new System.Windows.Forms.TextBox();
			this.txt21 = new System.Windows.Forms.TextBox();
			this.txt24 = new System.Windows.Forms.TextBox();
			this.txt23 = new System.Windows.Forms.TextBox();
			this.txt20 = new System.Windows.Forms.TextBox();
			this.txt22 = new System.Windows.Forms.TextBox();
			this.txt27 = new System.Windows.Forms.TextBox();
			this.txt26 = new System.Windows.Forms.TextBox();
			this.txt29 = new System.Windows.Forms.TextBox();
			this.txt28 = new System.Windows.Forms.TextBox();
			this.txt25 = new System.Windows.Forms.TextBox();
			this.cmb1 = new System.Windows.Forms.ComboBox();
			this.txt4 = new System.Windows.Forms.TextBox();
			this.txt5 = new System.Windows.Forms.TextBox();
			this.txt6 = new System.Windows.Forms.TextBox();
			this.txt7 = new System.Windows.Forms.TextBox();
			this.cmb2 = new System.Windows.Forms.ComboBox();
			this.txt9 = new System.Windows.Forms.TextBox();
			this.txt8 = new System.Windows.Forms.TextBox();
			this.label4 = new System.Windows.Forms.Label();
			this.label5 = new System.Windows.Forms.Label();
			this.label6 = new System.Windows.Forms.Label();
			this.label7 = new System.Windows.Forms.Label();
			this.label8 = new System.Windows.Forms.Label();
			this.label9 = new System.Windows.Forms.Label();
			this.label10 = new System.Windows.Forms.Label();
			this.label11 = new System.Windows.Forms.Label();
			this.label12 = new System.Windows.Forms.Label();
			this.label13 = new System.Windows.Forms.Label();
			this.label14 = new System.Windows.Forms.Label();
			this.label15 = new System.Windows.Forms.Label();
			this.label16 = new System.Windows.Forms.Label();
			this.label17 = new System.Windows.Forms.Label();
			this.label18 = new System.Windows.Forms.Label();
			this.label19 = new System.Windows.Forms.Label();
			this.label20 = new System.Windows.Forms.Label();
			this.label21 = new System.Windows.Forms.Label();
			this.label22 = new System.Windows.Forms.Label();
			this.label23 = new System.Windows.Forms.Label();
			this.label24 = new System.Windows.Forms.Label();
			this.label25 = new System.Windows.Forms.Label();
			this.label26 = new System.Windows.Forms.Label();
			this.label27 = new System.Windows.Forms.Label();
			this.label28 = new System.Windows.Forms.Label();
			this.da2 = new System.Data.SqlClient.SqlDataAdapter();
			this.sqlSelectCommand2 = new System.Data.SqlClient.SqlCommand();
			((System.ComponentModel.ISupportInitialize)(this.dataSet11)).BeginInit();
			((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
			this.groupBox1.SuspendLayout();
			this.groupBox2.SuspendLayout();
			this.SuspendLayout();
			// 
			// da1
			// 
			this.da1.DeleteCommand = this.sqlDeleteCommand1;
			this.da1.InsertCommand = this.sqlInsertCommand1;
			this.da1.SelectCommand = this.sqlSelectCommand1;
			this.da1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																						  new System.Data.Common.DataTableMapping("Table", "物料主文件", new System.Data.Common.DataColumnMapping[] {
																																																   new System.Data.Common.DataColumnMapping("物料编号", "物料编号"),
																																																   new System.Data.Common.DataColumnMapping("条码", "条码"),
																																																   new System.Data.Common.DataColumnMapping("物料名称", "物料名称"),
																																																   new System.Data.Common.DataColumnMapping("拼音编码", "拼音编码"),
																																																   new System.Data.Common.DataColumnMapping("计量单位", "计量单位"),
																																																   new System.Data.Common.DataColumnMapping("规格型号", "规格型号"),
																																																   new System.Data.Common.DataColumnMapping("计划类别", "计划类别"),
																																																   new System.Data.Common.DataColumnMapping("状态类别", "状态类别"),
																																																   new System.Data.Common.DataColumnMapping("归属类别", "归属类别"),