client.cs

《C#数据库项目案例导航》一书的配套光盘

			this.textId.Text = "";
			// 
			// groupBox2
			// 
			this.groupBox2.Controls.Add(this.textRemark);
			this.groupBox2.Location = new System.Drawing.Point(312, 104);
			this.groupBox2.Name = "groupBox2";
			this.groupBox2.Size = new System.Drawing.Size(240, 160);
			this.groupBox2.TabIndex = 9;
			this.groupBox2.TabStop = false;
			this.groupBox2.Text = "信息备注";
			// 
			// textRemark
			// 
			this.textRemark.Location = new System.Drawing.Point(16, 24);
			this.textRemark.Multiline = true;
			this.textRemark.Name = "textRemark";
			this.textRemark.Size = new System.Drawing.Size(208, 120);
			this.textRemark.TabIndex = 0;
			this.textRemark.Text = "";
			// 
			// label8
			// 
			this.label8.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label8.Location = new System.Drawing.Point(8, 280);
			this.label8.Name = "label8";
			this.label8.Size = new System.Drawing.Size(72, 23);
			this.label8.TabIndex = 7;
			this.label8.Text = "公司主页";
			// 
			// label7
			// 
			this.label7.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label7.Location = new System.Drawing.Point(8, 232);
			this.label7.Name = "label7";
			this.label7.Size = new System.Drawing.Size(72, 23);
			this.label7.TabIndex = 6;
			this.label7.Text = "公司传真";
			// 
			// label5
			// 
			this.label5.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label5.Location = new System.Drawing.Point(8, 192);
			this.label5.Name = "label5";
			this.label5.Size = new System.Drawing.Size(72, 23);
			this.label5.TabIndex = 4;
			this.label5.Text = "联系电话";
			// 
			// label4
			// 
			this.label4.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label4.Location = new System.Drawing.Point(296, 24);
			this.label4.Name = "label4";
			this.label4.Size = new System.Drawing.Size(72, 23);
			this.label4.TabIndex = 3;
			this.label4.Text = "公司地址";
			// 
			// label3
			// 
			this.label3.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label3.Location = new System.Drawing.Point(8, 152);
			this.label3.Name = "label3";
			this.label3.Size = new System.Drawing.Size(72, 23);
			this.label3.TabIndex = 2;
			this.label3.Text = "联系人";
			// 
			// label2
			// 
			this.label2.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label2.Location = new System.Drawing.Point(8, 104);
			this.label2.Name = "label2";
			this.label2.Size = new System.Drawing.Size(72, 23);
			this.label2.TabIndex = 1;
			this.label2.Text = "公司名称";
			// 
			// label1
			// 
			this.label1.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label1.Location = new System.Drawing.Point(8, 64);
			this.label1.Name = "label1";
			this.label1.Size = new System.Drawing.Size(72, 23);
			this.label1.TabIndex = 0;
			this.label1.Text = "客户编号";
			// 
			// label6
			// 
			this.label6.Font = new System.Drawing.Font("宋体", 9F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((System.Byte)(134)));
			this.label6.Location = new System.Drawing.Point(296, 64);
			this.label6.Name = "label6";
			this.label6.Size = new System.Drawing.Size(72, 23);
			this.label6.TabIndex = 5;
			this.label6.Text = "邮政编码";
			// 
			// textPostalCode
			// 
			this.textPostalCode.Location = new System.Drawing.Point(376, 56);
			this.textPostalCode.Name = "textPostalCode";
			this.textPostalCode.Size = new System.Drawing.Size(120, 23);
			this.textPostalCode.TabIndex = 16;
			this.textPostalCode.Text = "";
			// 
			// btnAdd
			// 
			this.btnAdd.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnAdd.Location = new System.Drawing.Point(36, 334);
			this.btnAdd.Name = "btnAdd";
			this.btnAdd.Size = new System.Drawing.Size(56, 24);
			this.btnAdd.TabIndex = 22;
			this.btnAdd.Text = "添加";
			this.btnAdd.Click += new System.EventHandler(this.btnAdd_Click);
			// 
			// btnDelete
			// 
			this.btnDelete.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnDelete.Location = new System.Drawing.Point(132, 334);
			this.btnDelete.Name = "btnDelete";
			this.btnDelete.Size = new System.Drawing.Size(56, 24);
			this.btnDelete.TabIndex = 23;
			this.btnDelete.Text = "删除";
			this.btnDelete.Click += new System.EventHandler(this.btnDelete_Click);
			// 
			// btnQuery
			// 
			this.btnQuery.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnQuery.Location = new System.Drawing.Point(212, 334);
			this.btnQuery.Name = "btnQuery";
			this.btnQuery.Size = new System.Drawing.Size(56, 24);
			this.btnQuery.TabIndex = 24;
			this.btnQuery.Text = "查询";
			this.btnQuery.Click += new System.EventHandler(this.btnQuery_Click);
			// 
			// btnModify
			// 
			this.btnModify.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnModify.Location = new System.Drawing.Point(292, 334);
			this.btnModify.Name = "btnModify";
			this.btnModify.Size = new System.Drawing.Size(56, 24);
			this.btnModify.TabIndex = 25;
			this.btnModify.Text = "修改";
			this.btnModify.Click += new System.EventHandler(this.btnModify_Click);
			// 
			// btnPrint
			// 
			this.btnPrint.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
			this.btnPrint.Location = new System.Drawing.Point(380, 334);
			this.btnPrint.Name = "btnPrint";
			this.btnPrint.Size = new System.Drawing.Size(56, 24);
			this.btnPrint.TabIndex = 26;
			this.btnPrint.Text = "报表";
			// 
			// btnExit
			// 
			this.btnExit.Location = new System.Drawing.Point(428, 374);
			this.btnExit.Name = "btnExit";
			this.btnExit.Size = new System.Drawing.Size(72, 24);
			this.btnExit.TabIndex = 27;
			this.btnExit.Text = "退出";
			this.btnExit.Click += new System.EventHandler(this.btnExit_Click);
			// 
			// btnCancel
			// 
			this.btnCancel.Location = new System.Drawing.Point(76, 374);
			this.btnCancel.Name = "btnCancel";
			this.btnCancel.Size = new System.Drawing.Size(72, 24);
			this.btnCancel.TabIndex = 28;
			this.btnCancel.Text = "取消";
			this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
			// 
			// sqlConnection1
			// 
			this.sqlConnection1.ConnectionString = "workstation id=\"TSINGHUA-AEBBD5\";packet size=4096;integrated security=SSPI;data s" +
				"ource=\"TSINGHUA-AEBBD5\";persist security info=False;initial catalog=Sell";
			// 
			// sqlDataAdapter1
			// 
			this.sqlDataAdapter1.DeleteCommand = this.sqlDeleteCommand1;
			this.sqlDataAdapter1.InsertCommand = this.sqlInsertCommand1;
			this.sqlDataAdapter1.SelectCommand = this.sqlSelectCommand1;
			this.sqlDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																									  new System.Data.Common.DataTableMapping("Table", "Client", new System.Data.Common.DataColumnMapping[] {
																																																				new System.Data.Common.DataColumnMapping("ClientId", "ClientId"),
																																																				new System.Data.Common.DataColumnMapping("ClientName", "ClientName"),
																																																				new System.Data.Common.DataColumnMapping("ClientPeople", "ClientPeople"),
																																																				new System.Data.Common.DataColumnMapping("ClientTelNo", "ClientTelNo"),
																																																				new System.Data.Common.DataColumnMapping("ClientFaxNo", "ClientFaxNo"),
																																																				new System.Data.Common.DataColumnMapping("ClientWebSite", "ClientWebSite"),
																																																				new System.Data.Common.DataColumnMapping("ClientAddress", "ClientAddress"),
																																																				new System.Data.Common.DataColumnMapping("ClientPostalCode", "ClientPostalCode"),
																																																				new System.Data.Common.DataColumnMapping("ClientRemark", "ClientRemark")})});
			this.sqlDataAdapter1.UpdateCommand = this.sqlUpdateCommand1;
			// 
			// sqlSelectCommand1
			// 
			this.sqlSelectCommand1.CommandText = "SELECT ClientId, ClientName, ClientPeople, ClientTelNo, ClientFaxNo, ClientWebSit" +
				"e, ClientAddress, ClientPostalCode, ClientRemark FROM Client";
			this.sqlSelectCommand1.Connection = this.sqlConnection1;
			// 
			// sqlInsertCommand1
			// 
			this.sqlInsertCommand1.CommandText = @"INSERT INTO Client(ClientId, ClientName, ClientPeople, ClientTelNo, ClientFaxNo, ClientWebSite, ClientAddress, ClientPostalCode, ClientRemark) VALUES (@ClientId, @ClientName, @ClientPeople, @ClientTelNo, @ClientFaxNo, @ClientWebSite, @ClientAddress, @ClientPostalCode, @ClientRemark); SELECT ClientId, ClientName, ClientPeople, ClientTelNo, ClientFaxNo, ClientWebSite, ClientAddress, ClientPostalCode, ClientRemark FROM Client WHERE (ClientId = @ClientId)";
			this.sqlInsertCommand1.Connection = this.sqlConnection1;
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientId", System.Data.SqlDbType.VarChar, 3, "ClientId"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientName", System.Data.SqlDbType.VarChar, 20, "ClientName"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientPeople", System.Data.SqlDbType.VarChar, 10, "ClientPeople"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientTelNo", System.Data.SqlDbType.VarChar, 20, "ClientTelNo"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientFaxNo", System.Data.SqlDbType.VarChar, 20, "ClientFaxNo"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientWebSite", System.Data.SqlDbType.VarChar, 50, "ClientWebSite"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientAddress", System.Data.SqlDbType.VarChar, 50, "ClientAddress"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientPostalCode", System.Data.SqlDbType.VarChar, 20, "ClientPostalCode"));
			this.sqlInsertCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientRemark", System.Data.SqlDbType.VarChar, 100, "ClientRemark"));
			// 
			// sqlUpdateCommand1
			// 
			this.sqlUpdateCommand1.CommandText = @"UPDATE Client SET ClientId = @ClientId, ClientName = @ClientName, ClientPeople = @ClientPeople, ClientTelNo = @ClientTelNo, ClientFaxNo = @ClientFaxNo, ClientWebSite = @ClientWebSite, ClientAddress = @ClientAddress, ClientPostalCode = @ClientPostalCode, ClientRemark = @ClientRemark WHERE (ClientId = @Original_ClientId) AND (ClientAddress = @Original_ClientAddress OR @Original_ClientAddress IS NULL AND ClientAddress IS NULL) AND (ClientFaxNo = @Original_ClientFaxNo OR @Original_ClientFaxNo IS NULL AND ClientFaxNo IS NULL) AND (ClientName = @Original_ClientName OR @Original_ClientName IS NULL AND ClientName IS NULL) AND (ClientPeople = @Original_ClientPeople OR @Original_ClientPeople IS NULL AND ClientPeople IS NULL) AND (ClientPostalCode = @Original_ClientPostalCode OR @Original_ClientPostalCode IS NULL AND ClientPostalCode IS NULL) AND (ClientRemark = @Original_ClientRemark OR @Original_ClientRemark IS NULL AND ClientRemark IS NULL) AND (ClientTelNo = @Original_ClientTelNo OR @Original_ClientTelNo IS NULL AND ClientTelNo IS NULL) AND (ClientWebSite = @Original_ClientWebSite OR @Original_ClientWebSite IS NULL AND ClientWebSite IS NULL); SELECT ClientId, ClientName, ClientPeople, ClientTelNo, ClientFaxNo, ClientWebSite, ClientAddress, ClientPostalCode, ClientRemark FROM Client WHERE (ClientId = @ClientId)";
			this.sqlUpdateCommand1.Connection = this.sqlConnection1;
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientId", System.Data.SqlDbType.VarChar, 3, "ClientId"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientName", System.Data.SqlDbType.VarChar, 20, "ClientName"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientPeople", System.Data.SqlDbType.VarChar, 10, "ClientPeople"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientTelNo", System.Data.SqlDbType.VarChar, 20, "ClientTelNo"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientFaxNo", System.Data.SqlDbType.VarChar, 20, "ClientFaxNo"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientWebSite", System.Data.SqlDbType.VarChar, 50, "ClientWebSite"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientAddress", System.Data.SqlDbType.VarChar, 50, "ClientAddress"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientPostalCode", System.Data.SqlDbType.VarChar, 20, "ClientPostalCode"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ClientRemark", System.Data.SqlDbType.VarChar, 100, "ClientRemark"));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientId", System.Data.SqlDbType.VarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientId", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientAddress", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientAddress", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientFaxNo", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientFaxNo", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientName", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientPeople", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientPeople", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientPostalCode", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientPostalCode", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientRemark", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientRemark", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientTelNo", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientTelNo", System.Data.DataRowVersion.Original, null));
			this.sqlUpdateCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientWebSite", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientWebSite", System.Data.DataRowVersion.Original, null));
			// 
			// sqlDeleteCommand1
			// 
			this.sqlDeleteCommand1.CommandText = @"DELETE FROM Client WHERE (ClientId = @Original_ClientId) AND (ClientAddress = @Original_ClientAddress OR @Original_ClientAddress IS NULL AND ClientAddress IS NULL) AND (ClientFaxNo = @Original_ClientFaxNo OR @Original_ClientFaxNo IS NULL AND ClientFaxNo IS NULL) AND (ClientName = @Original_ClientName OR @Original_ClientName IS NULL AND ClientName IS NULL) AND (ClientPeople = @Original_ClientPeople OR @Original_ClientPeople IS NULL AND ClientPeople IS NULL) AND (ClientPostalCode = @Original_ClientPostalCode OR @Original_ClientPostalCode IS NULL AND ClientPostalCode IS NULL) AND (ClientRemark = @Original_ClientRemark OR @Original_ClientRemark IS NULL AND ClientRemark IS NULL) AND (ClientTelNo = @Original_ClientTelNo OR @Original_ClientTelNo IS NULL AND ClientTelNo IS NULL) AND (ClientWebSite = @Original_ClientWebSite OR @Original_ClientWebSite IS NULL AND ClientWebSite IS NULL)";
			this.sqlDeleteCommand1.Connection = this.sqlConnection1;
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientId", System.Data.SqlDbType.VarChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientId", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientAddress", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientAddress", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientFaxNo", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientFaxNo", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientName", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientName", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientPeople", System.Data.SqlDbType.VarChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientPeople", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientPostalCode", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientPostalCode", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientRemark", System.Data.SqlDbType.VarChar, 100, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientRemark", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientTelNo", System.Data.SqlDbType.VarChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientTelNo", System.Data.DataRowVersion.Original, null));
			this.sqlDeleteCommand1.Parameters.Add(new System.Data.SqlClient.SqlParameter("@Original_ClientWebSite", System.Data.SqlDbType.VarChar, 50, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "ClientWebSite", System.Data.DataRowVersion.Original, null));
			// 
			// objDataSetClient
			// 
			this.objDataSetClient.DataSetName = "DataSetClient";
			this.objDataSetClient.Locale = new System.Globalization.CultureInfo("zh-CN");
			// 
			// Client
			// 
			this.AutoScaleBaseSize = new System.Drawing.Size(6, 14);
			this.ClientSize = new System.Drawing.Size(616, 405);
			this.Controls.Add(this.btnApply);
			this.Controls.Add(this.groupBox1);
			this.Controls.Add(this.btnAdd);
			this.Controls.Add(this.btnDelete);
			this.Controls.Add(this.btnQuery);
			this.Controls.Add(this.btnModify);
			this.Controls.Add(this.btnPrint);
			this.Controls.Add(this.btnExit);
			this.Controls.Add(this.btnCancel);
			this.Name = "Client";
			this.Text = "客户信息维护";
			this.Load += new System.EventHandler(this.Client_Load);
			this.groupBox1.ResumeLayout(false);
			this.groupBox2.ResumeLayout(false);
			((System.ComponentModel.ISupportInitialize)(this.objDataSetClient)).EndInit();
			this.ResumeLayout(false);

		}
		#endregion

		public void ErrorHandle(System.Exception E)
		{
			MessageBox.Show(E.ToString());
		}		

		private void ButtonPositonChange()
		{