form1.cs

来自「masterdetail program about C#」· CS 代码 · 共 551 行 · 第 1/5 页

			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IlKod1", System.Data.OleDb.OleDbType.VarWChar, 2, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IlKod", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IlceKod", System.Data.OleDb.OleDbType.VarWChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IlceKod", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_IlceKod1", System.Data.OleDb.OleDbType.VarWChar, 3, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "IlceKod", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_MahKoy", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "MahKoy", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_MahKoy1", System.Data.OleDb.OleDbType.VarWChar, 20, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "MahKoy", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Sira", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Sira", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Sira1", System.Data.OleDb.OleDbType.VarWChar, 10, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Sira", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Soyad", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Soyad", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Soyad1", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Soyad", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Tel", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Tel", System.Data.DataRowVersion.Original, null));
			this.oleDbDeleteCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Tel1", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Tel", System.Data.DataRowVersion.Original, null));
			// 
			// daKimlik
			// 
			this.daKimlik.DeleteCommand = this.oleDbDeleteCommand1;
			this.daKimlik.InsertCommand = this.oleDbInsertCommand1;
			this.daKimlik.SelectCommand = this.oleDbSelectCommand1;
			this.daKimlik.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																							   new System.Data.Common.DataTableMapping("Table", "kimlik", new System.Data.Common.DataColumnMapping[] {
																																																		 new System.Data.Common.DataColumnMapping("Ad", "Ad"),
																																																		 new System.Data.Common.DataColumnMapping("Adres", "Adres"),
																																																		 new System.Data.Common.DataColumnMapping("Aile", "Aile"),
																																																		 new System.Data.Common.DataColumnMapping("Anne", "Anne"),
																																																		 new System.Data.Common.DataColumnMapping("Baba", "Baba"),
																																																		 new System.Data.Common.DataColumnMapping("BitLise", "BitLise"),
																																																		 new System.Data.Common.DataColumnMapping("Cilt", "Cilt"),
																																																		 new System.Data.Common.DataColumnMapping("DTarihi", "DTarihi"),
																																																		 new System.Data.Common.DataColumnMapping("DYeri", "DYeri"),
																																																		 new System.Data.Common.DataColumnMapping("EMail", "EMail"),
																																																		 new System.Data.Common.DataColumnMapping("IlceKod", "IlceKod"),
																																																		 new System.Data.Common.DataColumnMapping("IlKod", "IlKod"),
																																																		 new System.Data.Common.DataColumnMapping("MahKoy", "MahKoy"),
																																																		 new System.Data.Common.DataColumnMapping("Numara", "Numara"),
																																																		 new System.Data.Common.DataColumnMapping("Sira", "Sira"),
																																																		 new System.Data.Common.DataColumnMapping("Soyad", "Soyad"),
																																																		 new System.Data.Common.DataColumnMapping("Tel", "Tel")})});
			this.daKimlik.UpdateCommand = this.oleDbUpdateCommand1;
			this.daKimlik.RowUpdated += new System.Data.OleDb.OleDbRowUpdatedEventHandler(this.daKimlik_RowUpdated);
			// 
			// button2
			// 
			this.button2.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.button2.ImageIndex = 1;
			this.button2.ImageList = this.iButton;
			this.button2.Location = new System.Drawing.Point(8, 400);
			this.button2.Name = "button2";
			this.button2.Size = new System.Drawing.Size(104, 24);
			this.button2.TabIndex = 2;
			this.button2.Text = "Detay Bilgileri";
			this.button2.TextAlign = System.Drawing.ContentAlignment.MiddleRight;
			this.button2.Click += new System.EventHandler(this.button2_Click);
			// 
			// button3
			// 
			this.button3.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.button3.ImageIndex = 3;
			this.button3.ImageList = this.iButton;
			this.button3.Location = new System.Drawing.Point(128, 400);
			this.button3.Name = "button3";
			this.button3.Size = new System.Drawing.Size(104, 24);
			this.button3.TabIndex = 3;
			this.button3.Text = "   Kay齮 Sil";
			this.button3.Click += new System.EventHandler(this.button3_Click);
			// 
			// button4
			// 
			this.button4.ImageAlign = System.Drawing.ContentAlignment.MiddleLeft;
			this.button4.ImageIndex = 4;
			this.button4.ImageList = this.iButton;
			this.button4.Location = new System.Drawing.Point(280, 16);
			this.button4.Name = "button4";
			this.button4.Size = new System.Drawing.Size(72, 24);
			this.button4.TabIndex = 4;
			this.button4.Text = "Liste";
			this.button4.Click += new System.EventHandler(this.button4_Click);
			// 
			// daDersler
			// 
			this.daDersler.DeleteCommand = this.oleDbCommand1;
			this.daDersler.InsertCommand = this.oleDbCommand2;
			this.daDersler.SelectCommand = this.oleDbCommand3;
			this.daDersler.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] {
																								new System.Data.Common.DataTableMapping("Table", "kimlik", new System.Data.Common.DataColumnMapping[] {
																																																		  new System.Data.Common.DataColumnMapping("Ad", "Ad"),
																																																		  new System.Data.Common.DataColumnMapping("Adres", "Adres"),
																																																		  new System.Data.Common.DataColumnMapping("Aile", "Aile"),
																																																		  new System.Data.Common.DataColumnMapping("Anne", "Anne"),
																																																		  new System.Data.Common.DataColumnMapping("Baba", "Baba"),
																																																		  new System.Data.Common.DataColumnMapping("BitLise", "BitLise"),
																																																		  new System.Data.Common.DataColumnMapping("Cilt", "Cilt"),
																																																		  new System.Data.Common.DataColumnMapping("DTarihi", "DTarihi"),
																																																		  new System.Data.Common.DataColumnMapping("DYeri", "DYeri"),
																																																		  new System.Data.Common.DataColumnMapping("EMail", "EMail"),
																																																		  new System.Data.Common.DataColumnMapping("IlceKod", "IlceKod"),
																																																		  new System.Data.Common.DataColumnMapping("IlKod", "IlKod"),
																																																		  new System.Data.Common.DataColumnMapping("MahKoy", "MahKoy"),
																																																		  new System.Data.Common.DataColumnMapping("Numara", "Numara"),
																																																		  new System.Data.Common.DataColumnMapping("Sira", "Sira"),
																																																		  new System.Data.Common.DataColumnMapping("Soyad", "Soyad"),
																																																		  new System.Data.Common.DataColumnMapping("Tel", "Tel")})});
			this.daDersler.UpdateCommand = this.oleDbCommand4;
			// 
			// oleDbCommand1
			// 
			this.oleDbCommand1.CommandText = @"DELETE FROM kimlik WHERE (Numara = ?) AND (Ad = ? OR ? IS NULL AND Ad IS NULL) AND (Adres = ? OR ? IS NULL AND Adres IS NULL) AND (Aile = ? OR ? IS NULL AND Aile IS NULL) AND (Anne = ? OR ? IS NULL AND Anne IS NULL) AND (Baba = ? OR ? IS NULL AND Baba IS NULL) AND (BitLise = ? OR ? IS NULL AND BitLise IS NULL) AND (Cilt = ? OR ? IS NULL AND Cilt IS NULL) AND (DTarihi = ? OR ? IS NULL AND DTarihi IS NULL) AND (DYeri = ? OR ? IS NULL AND DYeri IS NULL) AND (EMail = ? OR ? IS NULL AND EMail IS NULL) AND (IlKod = ? OR ? IS NULL AND IlKod IS NULL) AND (IlceKod = ? OR ? IS NULL AND IlceKod IS NULL) AND (MahKoy = ? OR ? IS NULL AND MahKoy IS NULL) AND (Sira = ? OR ? IS NULL AND Sira IS NULL) AND (Soyad = ? OR ? IS NULL AND Soyad IS NULL) AND (Tel = ? OR ? IS NULL AND Tel IS NULL)";
			this.oleDbCommand1.Connection = this.cListe;
			this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Numara", System.Data.OleDb.OleDbType.VarWChar, 9, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Numara", System.Data.DataRowVersion.Original, null));
			this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Ad", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Ad", System.Data.DataRowVersion.Original, null));
			this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Ad1", System.Data.OleDb.OleDbType.VarWChar, 15, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Ad", System.Data.DataRowVersion.Original, null));
			this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Adres", System.Data.OleDb.OleDbType.VarWChar, 80, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Adres", System.Data.DataRowVersion.Original, null));
			this.oleDbCommand1.Parameters.Add(new System.Data.OleDb.OleDbParameter("Original_Adres1", System.Data.OleDb.OleDbType.VarWChar, 80, System.Data.ParameterDirection.Input, false, ((System.Byte)(0)), ((System.Byte)(0)), "Adres", System.Data.DataRowVersion.Original, null));