form1.cs

来自「关于C#用DES对文件加解密操作及用C#操作SQL Server图像处理」· CS 代码 · 共 576 行 · 第 1/3 页

			this.groupBox1.Controls.Add(this.textBox2);
			this.groupBox1.Controls.Add(this.textBox1);
			this.groupBox1.Controls.Add(this.label3);
			this.groupBox1.Controls.Add(this.label1);
			this.groupBox1.Controls.Add(this.label2);
			this.groupBox1.Controls.Add(this.label4);
			this.groupBox1.Controls.Add(this.label7);
			this.groupBox1.Controls.Add(this.label8);
			this.groupBox1.Controls.Add(this.label5);
			this.groupBox1.Controls.Add(this.label6);
			this.groupBox1.Location = new System.Drawing.Point(8, 8);
			this.groupBox1.Name = "groupBox1";
			this.groupBox1.Size = new System.Drawing.Size(216, 224);
			this.groupBox1.TabIndex = 8;
			this.groupBox1.TabStop = false;
			this.groupBox1.Text = "数据库信息";
			// 
			// textBox1
			// 
			this.textBox1.Location = new System.Drawing.Point(96, 16);
			this.textBox1.Name = "textBox1";
			this.textBox1.TabIndex = 8;
			this.textBox1.Text = "textBox1";
			// 
			// textBox2
			// 
			this.textBox2.Location = new System.Drawing.Point(96, 40);
			this.textBox2.Name = "textBox2";
			this.textBox2.TabIndex = 9;
			this.textBox2.Text = "textBox2";
			// 
			// textBox3
			// 
			this.textBox3.Location = new System.Drawing.Point(96, 64);
			this.textBox3.Name = "textBox3";
			this.textBox3.TabIndex = 10;
			this.textBox3.Text = "textBox3";
			// 
			// textBox4
			// 
			this.textBox4.Location = new System.Drawing.Point(96, 88);
			this.textBox4.Name = "textBox4";
			this.textBox4.TabIndex = 11;
			this.textBox4.Text = "textBox4";
			// 
			// textBox5
			// 
			this.textBox5.Location = new System.Drawing.Point(96, 112);
			this.textBox5.Name = "textBox5";
			this.textBox5.TabIndex = 12;
			this.textBox5.Text = "textBox5";
			// 
			// textBox6
			// 
			this.textBox6.Location = new System.Drawing.Point(96, 136);
			this.textBox6.Name = "textBox6";
			this.textBox6.TabIndex = 13;
			this.textBox6.Text = "textBox6";
			// 
			// textBox7
			// 
			this.textBox7.Location = new System.Drawing.Point(96, 160);
			this.textBox7.Name = "textBox7";
			this.textBox7.TabIndex = 14;
			this.textBox7.Text = "textBox7";
			// 
			// textBox8
			// 
			this.textBox8.Location = new System.Drawing.Point(96, 184);
			this.textBox8.Name = "textBox8";
			this.textBox8.TabIndex = 15;
			this.textBox8.Text = "textBox8";
			// 
			// button1
			// 
			this.button1.Location = new System.Drawing.Point(256, 8);
			this.button1.Name = "button1";
			this.button1.TabIndex = 9;
			this.button1.Text = "第一条";
			this.button1.Click += new System.EventHandler(this.button1_Click);
			// 
			// button2
			// 
			this.button2.Location = new System.Drawing.Point(256, 32);
			this.button2.Name = "button2";
			this.button2.TabIndex = 10;
			this.button2.Text = "前一条";
			this.button2.Click += new System.EventHandler(this.button2_Click);
			// 
			// button3
			// 
			this.button3.Location = new System.Drawing.Point(256, 56);
			this.button3.Name = "button3";
			this.button3.TabIndex = 11;
			this.button3.Text = "后一条";
			this.button3.Click += new System.EventHandler(this.button3_Click);
			// 
			// button4
			// 
			this.button4.Location = new System.Drawing.Point(256, 80);
			this.button4.Name = "button4";
			this.button4.TabIndex = 12;
			this.button4.Text = "未一条";
			this.button4.Click += new System.EventHandler(this.button4_Click);
			// 
			// button5
			// 
			this.button5.Location = new System.Drawing.Point(256, 104);
			this.button5.Name = "button5";
			this.button5.TabIndex = 13;
			this.button5.Text = "新建记录";
			this.button5.Click += new System.EventHandler(this.button5_Click);
			// 
			// button6
			// 
			this.button6.Location = new System.Drawing.Point(256, 128);
			this.button6.Name = "button6";
			this.button6.TabIndex = 14;
			this.button6.Text = "增加记录";
			// 
			// button7
			// 
			this.button7.Location = new System.Drawing.Point(256, 152);
			this.button7.Name = "button7";
			this.button7.TabIndex = 15;
			this.button7.Text = "修改记录";
			// 
			// button8
			// 
			this.button8.Location = new System.Drawing.Point(256, 176);
			this.button8.Name = "button8";
			this.button8.TabIndex = 16;
			this.button8.Text = "删除记录";
			// 
			// button9
			// 
			this.button9.Location = new System.Drawing.Point(256, 200);
			this.button9.Name = "button9";
			this.button9.TabIndex = 17;
			this.button9.Text = "关闭程序";
			// 
			// oleDbDataAdapter1
			// 
			this.oleDbDataAdapter1.DeleteCommand = this.oleDbDeleteCommand1;
			this.oleDbDataAdapter1.InsertCommand = this.oleDbInsertCommand1;
			this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;
			this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																										new System.Data.Common.DataTableMapping("Table", "message", new System.Data.Common.DataColumnMapping[] {
																																																				   new System.Data.Common.DataColumnMapping("Expr1", "Expr1"),
																																																				   new System.Data.Common.DataColumnMapping("Expr2", "Expr2"),
																																																				   new System.Data.Common.DataColumnMapping("Expr3", "Expr3"),
																																																				   new System.Data.Common.DataColumnMapping("Expr4", "Expr4"),
																																																				   new System.Data.Common.DataColumnMapping("Expr5", "Expr5"),
																																																				   new System.Data.Common.DataColumnMapping("Expr6", "Expr6"),
																																																				   new System.Data.Common.DataColumnMapping("Expr7", "Expr7"),
																																																				   new System.Data.Common.DataColumnMapping("Expr8", "Expr8"),
																																																				   new System.Data.Common.DataColumnMapping("Expr9", "Expr9"),
																																																				   new System.Data.Common.DataColumnMapping("address", "address"),
																																																				   new System.Data.Common.DataColumnMapping("city", "city"),
																																																				   new System.Data.Common.DataColumnMapping("id", "id"),
																																																				   new System.Data.Common.DataColumnMapping("mail", "mail"),
																																																				   new System.Data.Common.DataColumnMapping("message", "message"),
																																																				   new System.Data.Common.DataColumnMapping("name", "name"),
																																																				   new System.Data.Common.DataColumnMapping("telphone", "telphone"),
																																																				   new System.Data.Common.DataColumnMapping("username", "username"),
																																																				   new System.Data.Common.DataColumnMapping("编号", "编号")})});
			this.oleDbDataAdapter1.UpdateCommand = this.oleDbUpdateCommand1;
			// 
			// oleDbSelectCommand1
			// 
			this.oleDbSelectCommand1.CommandText = "SELECT address AS Expr1, city AS Expr2, id AS Expr3, mail AS Expr4, message AS Ex" +
				"pr5, name AS Expr6, telphone AS Expr7, username AS Expr8, 编号 AS Expr9, address, " +
				"city, id, mail, message, name, telphone, username, 编号 FROM message";
			this.oleDbSelectCommand1.Connection = this.oleDbConnection1;
			// 
			// oleDbInsertCommand1
			// 
			this.oleDbInsertCommand1.CommandText = "INSERT INTO message(address, city, id, mail, message, name, telphone, username) V" +
				"ALUES (?, ?, ?, ?, ?, ?, ?, ?)";
			this.oleDbInsertCommand1.Connection = this.oleDbConnection1;
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("address", System.Data.OleDb.OleDbType.VarWChar, 50, "address"));
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("city", System.Data.OleDb.OleDbType.VarWChar, 50, "city"));
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("id", System.Data.OleDb.OleDbType.Integer, 0, "id"));
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("mail", System.Data.OleDb.OleDbType.VarWChar, 50, "mail"));
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("message", System.Data.OleDb.OleDbType.VarWChar, 50, "message"));
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("name", System.Data.OleDb.OleDbType.VarWChar, 50, "name"));
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("telphone", System.Data.OleDb.OleDbType.VarWChar, 50, "telphone"));
			this.oleDbInsertCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("username", System.Data.OleDb.OleDbType.VarWChar, 50, "username"));
			// 
			// oleDbUpdateCommand1
			// 
			this.oleDbUpdateCommand1.CommandText = @"UPDATE message SET address = ?, city = ?, id = ?, mail = ?, message = ?, name = ?, telphone = ?, username = ? WHERE (编号 = ?) AND (address = ? OR ? IS NULL AND address IS NULL) AND (city = ? OR ? IS NULL AND city IS NULL) AND (id = ? OR ? IS NULL AND id IS NULL) AND (mail = ? OR ? IS NULL AND mail IS NULL) AND (message = ? OR ? IS NULL AND message IS NULL) AND (name = ? OR ? IS NULL AND name IS NULL) AND (telphone = ? OR ? IS NULL AND telphone IS NULL) AND (username = ? OR ? IS NULL AND username IS NULL) AND (address = ? OR ? IS NULL AND address IS NULL) AND (city = ? OR ? IS NULL AND city IS NULL) AND (id = ? OR ? IS NULL AND id IS NULL) AND (mail = ? OR ? IS NULL AND mail IS NULL) AND (message = ? OR ? IS NULL AND message IS NULL) AND (name = ? OR ? IS NULL AND name IS NULL) AND (telphone = ? OR ? IS NULL AND telphone IS NULL) AND (username = ? OR ? IS NULL AND username IS NULL)";