TFF Hakem Takip Programı C#
Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.
FORM1 İçerisine Yazılacak Kodlar…
[code language=”CSharp”]
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Data.OleDb;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Data.OleDb; //oledbli komutların gelmesi için bunu yazdık
using System.Windows.Forms;
namespace WindowsFormsApplication13
{
public partial class Form1 : Form
{
public Form1 frm1;
public Form2 frm2;
public Form3 frm3;
public Form4 frm4;
public Form5 frm5;
public Form6 frm6;
public Form7 frm7;
public Form8 frm8;
public Form9 frm9;
public Form1()
{
InitializeComponent();
frm2 = new Form2();
frm3 = new Form3();
frm4 = new Form4();
frm5 = new Form5();
frm6 = new Form6();
frm7 = new Form7();
frm8 = new Form8();
frm9 = new Form9();
frm2.frm1 = this;
frm3.frm1 = this;
frm4.frm1 = this;
frm5.frm1 = this;
frm6.frm1 = this;
frm7.frm1 = this;
frm8.frm1 = this;
frm9.frm1 = this;
}
public OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Jet.OleDb.4.0;Data Source= vt1.mdb");
public DataSet dtst = new DataSet();
public OleDbCommand kmt = new OleDbCommand();
public void listele1() //hif hakemleri listelicek
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * from hif_h", bag);
adtr.Fill(dtst, "hif_h");
frm2.dataGridView1.DataSource = dtst; //form2 deki datadriglerin görünmesi için modifilers özelliğini public yaptık
frm2.dataGridView1.DataMember = "hif_h";
bag.Close();
adtr.Dispose();
}
public void listele2() //klasman hakemleri listelicek
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * from klas_h", bag);
adtr.Fill(dtst, "klas_h");
frm3.dataGridView1.DataSource = dtst; //form3 deki datadriglerin görünmesi için modifilers özelliğini public yaptık
frm3.dataGridView1.DataMember = "klas_h";
bag.Close();
adtr.Dispose();
}
public void listele3() //il hakemleri listelicek
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * from il_h", bag);
adtr.Fill(dtst, "il_h");
frm4.dataGridView1.DataSource = dtst; //form4 deki datadriglerin görünmesi için modifilers özelliğini public yaptık
frm4.dataGridView1.DataMember = "il_h";
bag.Close();
adtr.Dispose();
}
public void listele4() //fifa hakemleri listelicek
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * from fifa_h", bag);
adtr.Fill(dtst, "fifa_h");
frm6.dataGridView1.DataSource = dtst; //form6 deki datadriglerin görünmesi için modifilers özelliğini public yaptık
frm6.dataGridView1.DataMember = "fifa_h";
bag.Close();
adtr.Dispose();
}
public void combo1()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from boshakem";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
frm5.comboBox1.Items.Add(oku[0].ToString()); //form5 deki comboların modilerf özellği public yaptık
frm5.comboBox2.Items.Add(oku[0].ToString());
frm5.comboBox3.Items.Add(oku[0].ToString());
frm5.comboBox4.Items.Add(oku[0].ToString());
frm5.comboBox5.Items.Add(oku[0].ToString());
frm5.comboBox6.Items.Add(oku[0].ToString());
frm5.comboBox7.Items.Add(oku[0].ToString());
frm5.comboBox8.Items.Add(oku[0].ToString());
frm5.comboBox9.Items.Add(oku[0].ToString());
frm5.comboBox10.Items.Add(oku[0].ToString());
frm5.comboBox11.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
frm5.comboBox1.Sorted = true;
}
private void Form1_Load(object sender, EventArgs e)
{
listele1();
listele2();
listele3();
listele4();
combo1();
}
private void button1_Click(object sender, EventArgs e)
{
frm2.Show();
this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
frm3.Show();
this.Hide();
}
private void button3_Click(object sender, EventArgs e)
{
frm4.Show();
this.Hide();
}
private void button4_Click(object sender, EventArgs e)
{
frm6.Show();
this.Hide();
}
private void button5_Click(object sender, EventArgs e)
{
frm5.Show();
this.Hide();
}
private void button8_Click(object sender, EventArgs e)
{
frm7.Show();
this.Hide();
}
private void button6_Click(object sender, EventArgs e)
{
frm8.Show();
this.Hide();
}
private void button7_Click(object sender, EventArgs e)
{
Close();
}
private void button9_Click(object sender, EventArgs e)
{
frm9.Show();
this.Hide();
}
}
}
[/code]
FORM2 İçerisine Yazılacak Kodlar…
[code language=”CSharp”]
public partial class Form2 : Form
{
public Form1 frm1;
public Form2()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
frm1.Show();
this.Hide();
}
private void button3_Click(object sender, EventArgs e)
{
frm1.frm8.Show();
this.Hide();
}
private void button4_Click(object sender, EventArgs e)
{
Close();
}
private void button2_Click(object sender, EventArgs e)
{
frm1.frm9.Show();
this.Hide();
}
}
[/code]
FORM3 İçerisine Yazılacak Kodlar…
[code language=”CSharp”]
public partial class Form3 : Form
{
public Form1 frm1;
public Form3()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
frm1.Show();
this.Hide();
}
private void button3_Click(object sender, EventArgs e)
{
frm1.frm8.Show();
this.Hide();
}
private void button4_Click(object sender, EventArgs e)
{
Close();
}
private void button2_Click(object sender, EventArgs e)
{
frm1.frm9.Show();
this.Hide();
}
}
[/code]
Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.
FORM4 İçerisine Yazılacak Kodlar…
[code language=”CSharp”]
public partial class Form4 : Form
{
public Form1 frm1;
public Form4()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
frm1.Show();
this.Hide();
}
private void button3_Click(object sender, EventArgs e)
{
frm1.frm8.Show();
this.Hide();
}
private void button4_Click(object sender, EventArgs e)
{
Close();
}
private void button2_Click(object sender, EventArgs e)
{
frm1.frm9.Show();
this.Hide();
}
}
[/code]
FORM5 İçerisine Yazılacak Kodlar…
[code language=”CSharp”]
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication13
{
public partial class Form5 : Form
{
public Form1 frm1;
public Form5()
{
InitializeComponent();
}
private void Form5_Load(object sender, EventArgs e)
{
button1.Enabled = false;
button5.Enabled = false;
button6.Enabled = false;
button7.Enabled = false;
button8.Enabled = false;
button9.Enabled = false;
button10.Enabled = false;
button11.Enabled = false;
button12.Enabled = false;
button13.Enabled = false;
button14.Enabled = false;
}
private void button2_Click(object sender, EventArgs e)
{
frm1.Show();
this.Hide();
}
private void button3_Click(object sender, EventArgs e)
{
frm1.frm9.Show();
this.Hide();
}
private void button4_Click(object sender, EventArgs e)
{
Close();
}
private void comboBox9_SelectedIndexChanged(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO doluhakem(adsoyad) VALUES (‘" + comboBox9.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from boshakem WHERE adsoyad=’" + comboBox9.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
//comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox9.Enabled = false;
button12.Enabled = true;
}
private void comboBox1_SelectedIndexChanged(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection =frm1. bag;
frm1.kmt.CommandText = "INSERT INTO doluhakem(adsoyad) VALUES (‘" + comboBox1.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from boshakem WHERE adsoyad=’" + comboBox1.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
//comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox1.Enabled = false;
button1.Enabled = true;
}
private void comboBox2_SelectedIndexChanged(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO doluhakem(adsoyad) VALUES (‘" + comboBox2.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from boshakem WHERE adsoyad=’" + comboBox2.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
//comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox2.Enabled = false;
button5.Enabled = true;
}
private void comboBox3_SelectedIndexChanged(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO doluhakem(adsoyad) VALUES (‘" + comboBox3.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from boshakem WHERE adsoyad=’" + comboBox3.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
//comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox3.Enabled = false;
button6.Enabled = true;
}
private void comboBox4_SelectedIndexChanged(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO doluhakem(adsoyad) VALUES (‘" + comboBox4.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from boshakem WHERE adsoyad=’" + comboBox4.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
//comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox4.Enabled = false;
button7.Enabled = true;
}
private void comboBox5_SelectedIndexChanged(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO doluhakem(adsoyad) VALUES (‘" + comboBox5.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from boshakem WHERE adsoyad=’" + comboBox5.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
//comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox5.Enabled = false;
button8.Enabled = true;
}
private void comboBox6_SelectedIndexChanged(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO doluhakem(adsoyad) VALUES (‘" + comboBox6.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from boshakem WHERE adsoyad=’" + comboBox6.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
//comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox6.Enabled = false;
button9.Enabled = true;
}
private void comboBox7_SelectedIndexChanged(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO doluhakem(adsoyad) VALUES (‘" + comboBox7.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from boshakem WHERE adsoyad=’" + comboBox7.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
//comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox7.Enabled = false;
button10.Enabled = true;
}
private void comboBox8_SelectedIndexChanged(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO doluhakem(adsoyad) VALUES (‘" + comboBox8.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from boshakem WHERE adsoyad=’" + comboBox8.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
// comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox8.Enabled = false;
button11.Enabled = true;
}
private void comboBox10_SelectedIndexChanged(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO doluhakem(adsoyad) VALUES (‘" + comboBox10.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from boshakem WHERE adsoyad=’" + comboBox10.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
//comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox10.Enabled = false;
button13.Enabled = true;
}
private void comboBox11_SelectedIndexChanged(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO doluhakem(adsoyad) VALUES (‘" + comboBox11.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from boshakem WHERE adsoyad=’" + comboBox11.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
//comboBox11.Items.Clear();
frm1.combo1();
comboBox11.Enabled = false;
button14.Enabled = true;
}
private void button12_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + comboBox9.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from doluhakem WHERE adsoyad=’" + comboBox9.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox9.Text = "Atanmamış";
comboBox9.Enabled = true;
button12.Enabled = false;
}
private void button1_Click_1(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + comboBox1.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from doluhakem WHERE adsoyad=’" + comboBox1.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox1.Text = "Atanmamış";
comboBox1.Enabled = true;
button1.Enabled = false;
}
private void button5_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + comboBox2.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from doluhakem WHERE adsoyad=’" + comboBox2.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox2.Text = "Atanmamış";
comboBox2.Enabled = true;
button5.Enabled = false;
}
private void button6_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + comboBox3.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from doluhakem WHERE adsoyad=’" + comboBox3.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox3.Text = "Atanmamış";
comboBox3.Enabled = true;
button6.Enabled = false;
}
private void button7_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + comboBox4.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from doluhakem WHERE adsoyad=’" + comboBox4.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox4.Text = "Atanmamış";
comboBox4.Enabled = true;
button7.Enabled = false;
}
private void button8_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + comboBox5.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from doluhakem WHERE adsoyad=’" + comboBox5.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox5.Text = "Atanmamış";
comboBox5.Enabled = true;
button8.Enabled = false;
}
private void button9_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + comboBox6.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from doluhakem WHERE adsoyad=’" + comboBox6.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox6.Text = "Atanmamış";
comboBox6.Enabled = true;
button9.Enabled = false;
}
private void button10_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + comboBox7.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from doluhakem WHERE adsoyad=’" + comboBox7.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox7.Text = "Atanmamış";
comboBox7.Enabled = true;
button10.Enabled = false;
}
private void button11_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + comboBox8.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from doluhakem WHERE adsoyad=’" + comboBox8.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox8.Text = "Atanmamış";
comboBox8.Enabled = true;
button11.Enabled = false;
}
private void button13_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + comboBox10.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from doluhakem WHERE adsoyad=’" + comboBox10.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox10.Text = "Atanmamış";
comboBox10.Enabled = true;
button13.Enabled = false;
}
private void button14_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + comboBox11.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from doluhakem WHERE adsoyad=’" + comboBox11.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
comboBox2.Items.Clear();
comboBox3.Items.Clear();
comboBox4.Items.Clear();
comboBox5.Items.Clear();
comboBox6.Items.Clear();
comboBox7.Items.Clear();
comboBox8.Items.Clear();
comboBox9.Items.Clear();
comboBox10.Items.Clear();
comboBox11.Items.Clear();
frm1.combo1();
comboBox11.Text = "Atanmamış";
comboBox11.Enabled = true;
button14.Enabled = false;
}
}
}
[/code]
Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.
FORM6 İçerisine Yazılacak Kodlar…
[code language=”CSharp”]
public partial class Form6 : Form
{
public Form1 frm1;
public Form6()
{
InitializeComponent();
}
private void button3_Click(object sender, EventArgs e)
{
frm1.frm8.Show();
this.Hide();
}
private void button1_Click(object sender, EventArgs e)
{
frm1.Show();
this.Hide();
}
private void button4_Click(object sender, EventArgs e)
{
Close();
}
private void button2_Click(object sender, EventArgs e)
{
frm1.frm9.Show();
this.Hide();
}
}
[/code]
FORM7 İçerisine Yazılacak Kodlar…
[code language=”CSharp”]
public partial class Form7 : Form
{
public Form1 frm1;
public Form7()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
frm1.Show();
this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
Close();
}
}
[/code]
FORM8 İçerisine Yazılacak Kodlar…
[code language=”CSharp”]
public partial class Form8 : Form
{
public Form1 frm1;
public Form8()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
frm1.Show();
this.Hide();
}
private void button2_Click(object sender, EventArgs e)
{
this.Hide();
}
}
[/code]
FORM9 İçerisine Yazılacak Kodlar…
[code language=”CSharp”]
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication13
{
public partial class Form9 : Form
{
public Form1 frm1;
public Form9()
{
InitializeComponent();
}
private void button3_Click(object sender, EventArgs e)
{
frm1.Show();
this.Hide();
}
private void button4_Click(object sender, EventArgs e)
{
frm1.frm8.Show();
this.Hide();
}
private void button5_Click(object sender, EventArgs e)
{
Close();
}
private void button1_Click(object sender, EventArgs e)
{
if (comboBox1.Text == "Seçiniz.." || comboBox2.Text == "Seçiniz.." || textBox1.Text=="" || textBox2.Text=="" || textBox3.Text=="")
{
MessageBox.Show("Lütfen Hakemlik Türü , Lisans Bilgilerini ve diğer gerekli bilgileri doldurunuz");
}
else
{
string adsoyad;
adsoyad = textBox2.Text + " " + textBox3.Text;
if (comboBox1.Text == "HİF")
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO hif_h(tc,ad,soyad,d_tarih,meslek,lisans) VALUES (‘" + textBox1.Text + "’,’" + textBox2.Text + "’,’" + textBox3.Text + "’,’" + textBox4.Text + "’, ‘" + textBox5.Text + "’, ‘" + comboBox2.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + adsoyad + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.bag.Close();
frm1.kmt.Dispose();
frm1.dtst.Clear();
frm1.listele1();
frm1.listele2();
frm1.listele3();
frm1.listele4();
}
if (comboBox1.Text == "KLASMAN")
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO klas_h(tc,ad,soyad,d_tarih,meslek,lisans) VALUES (‘" + textBox1.Text + "’,’" + textBox2.Text + "’,’" + textBox3.Text + "’,’" + textBox4.Text + "’, ‘" + textBox5.Text + "’, ‘" + comboBox2.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + adsoyad + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.bag.Close();
frm1.kmt.Dispose();
frm1.dtst.Clear();
frm1.listele1();
frm1.listele2();
frm1.listele3();
frm1.listele4();
}
if (comboBox1.Text == "İL")
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO il_h(tc,ad,soyad,d_tarih,meslek,lisans) VALUES (‘" + textBox1.Text + "’,’" + textBox2.Text + "’,’" + textBox3.Text + "’,’" + textBox4.Text + "’, ‘" + textBox5.Text + "’, ‘" + comboBox2.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + adsoyad + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.bag.Close();
frm1.kmt.Dispose();
frm1.dtst.Clear();
frm1.listele1();
frm1.listele2();
frm1.listele3();
frm1.listele4();
}
if (comboBox1.Text == "FİFA")
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO fifa_h(tc,ad,soyad,d_tarih,meslek,lisans) VALUES (‘" + textBox1.Text + "’,’" + textBox2.Text + "’,’" + textBox3.Text + "’,’" + textBox4.Text + "’, ‘" + textBox5.Text + "’, ‘" + comboBox2.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "INSERT INTO boshakem(adsoyad) VALUES (‘" + adsoyad + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.bag.Close();
frm1.kmt.Dispose();
frm1.dtst.Clear();
frm1.listele1();
frm1.listele2();
frm1.listele3();
frm1.listele4();
}
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
comboBox1.Text = "Seçiniz..";
comboBox2.Text = "Seçiniz..";
frm1.frm5.comboBox1.Items.Clear();
frm1.frm5.comboBox2.Items.Clear();
frm1.frm5.comboBox3.Items.Clear();
frm1.frm5.comboBox4.Items.Clear();
frm1.frm5.comboBox5.Items.Clear();
frm1.frm5.comboBox6.Items.Clear();
frm1.frm5.comboBox7.Items.Clear();
frm1.frm5.comboBox8.Items.Clear();
frm1.frm5.comboBox9.Items.Clear();
frm1.frm5.comboBox10.Items.Clear();
frm1.frm5.comboBox11.Items.Clear();
frm1.combo1();
}
}
}
}
[/code]
Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.