materialsform.cs

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

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

namespace 生产管理系统
{
	/// <summary>
	/// MaterialsForm 的摘要说明。
	/// </summary>
	public class MaterialsForm : System.Windows.Forms.Form
	{
		//设置连接字符串
		private CurrencyManager cmOrders;
		//设置数据链接
		private SqlConnection tempConnection = new SqlConnection("workstation id=localhost;Integrated Security=SSPI;database=mrpbook;") ;

		private System.Data.SqlClient.SqlConnection sqlConnection1;
		private 生产管理系统.DataSet1 dataSet11;
		private System.Windows.Forms.DataGrid dataGrid1;
		private System.Windows.Forms.GroupBox groupBox1;
		private System.Windows.Forms.ToolBar toolBar1;
		private System.Windows.Forms.ImageList imageList1;
		private System.Windows.Forms.Button btnSearch;
		private System.Windows.Forms.Label label1;
		private System.Windows.Forms.TextBox txt2;
		private System.Windows.Forms.TextBox txt1;
		private System.Windows.Forms.Label label2;
		private System.Windows.Forms.TextBox txt3;
		private System.Windows.Forms.Label label3;
		private System.Windows.Forms.GroupBox groupBox2;
		private System.Windows.Forms.Label label4;
		private System.Windows.Forms.Label label5;
		private System.Windows.Forms.Label label6;
		private System.Windows.Forms.Label label7;
		private System.Windows.Forms.Label label8;
		private System.Windows.Forms.Label label9;
		private System.Windows.Forms.Label label10;
		private System.Windows.Forms.ToolBarButton tBtnFirst;
		private System.Windows.Forms.ToolBarButton tBtnPre;
		private System.Windows.Forms.ToolBarButton tBtnNext;
		private System.Windows.Forms.ToolBarButton tBtnLast;
		private System.Windows.Forms.ToolBarButton tBtnNew;
		private System.Windows.Forms.ToolBarButton tBtnDelete;
		private System.Windows.Forms.ToolBarButton tBtnSubmit;
		private System.Windows.Forms.ToolBarButton tBtnEdit;
		private System.Windows.Forms.DataGridTableStyle dataGridTableStyle1;
		private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn1;
		private System.Windows.Forms.DataGridTextBoxColumn dataGridTextBoxColumn2;
		private System.Windows.Forms.Label label11;
		private System.Windows.Forms.Label label12;
		private System.Windows.Forms.Label label13;
		private System.Windows.Forms.Label label14;
		private System.Windows.Forms.Label label15;
		private System.Windows.Forms.Label label16;
		private System.Windows.Forms.Label label17;
		private System.Windows.Forms.Label label18;
		private System.Windows.Forms.Label label19;
		private System.Windows.Forms.Label label20;
		private System.Windows.Forms.Label label21;
		private System.Windows.Forms.Label label22;
		private System.Windows.Forms.Label label23;
		private System.Windows.Forms.Label label24;
		private System.Windows.Forms.Label label25;
		private System.Windows.Forms.Label label26;
		private System.Windows.Forms.Label label27;
		private System.Windows.Forms.Label label28;
		private System.Data.SqlClient.SqlDataAdapter da1;
		private System.Data.SqlClient.SqlDataAdapter da2;
		private System.Data.SqlClient.SqlCommand sqlSelectCommand2;
		private System.Windows.Forms.ComboBox cmb1;
		private System.Windows.Forms.TextBox txt4;
		private System.Windows.Forms.TextBox txt5;
		private System.Windows.Forms.TextBox txt6;
		private System.Windows.Forms.TextBox txt7;
		private System.Windows.Forms.ComboBox cmb2;
		private System.Windows.Forms.TextBox txt9;
		private System.Windows.Forms.TextBox txt8;
		private System.Windows.Forms.TextBox txt12;
		private System.Windows.Forms.TextBox txt11;
		private System.Windows.Forms.TextBox txt10;
		private System.Windows.Forms.TextBox txt13;
		private System.Windows.Forms.TextBox txt15;
		private System.Windows.Forms.TextBox txt16;
		private System.Windows.Forms.TextBox txt14;
		private System.Windows.Forms.TextBox txt17;
		private System.Windows.Forms.TextBox txt19;
		private System.Windows.Forms.TextBox txt18;
		private System.Windows.Forms.TextBox txt21;
		private System.Windows.Forms.TextBox txt24;
		private System.Windows.Forms.TextBox txt23;
		private System.Windows.Forms.TextBox txt20;
		private System.Windows.Forms.TextBox txt22;
		private System.Windows.Forms.TextBox txt27;
		private System.Windows.Forms.TextBox txt26;
		private System.Windows.Forms.TextBox txt29;
		private System.Windows.Forms.TextBox txt28;
		private System.Windows.Forms.TextBox txt25;
		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.Windows.Forms.ToolBarButton tBtnQuit;
		private System.Windows.Forms.ToolBarButton tBtnCancel;
		private System.ComponentModel.IContainer components;

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

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

		/// <summary>
		/// 清理所有正在使用的资源。
		/// </summary>
		protected override void Dispose( bool disposing )
		{
			if( disposing )