Halı Saha Takip Programı v2.0 C#.NET(CNET)

Halı Saha Takip Programı v2.0 C#.NET(CNET)…

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

Önemli Not: Tüm Buttonlar için geçerli olan kodları yazdım sadece haftanıın diğer günleri içinde yazılması gerek kod aşağıdaki gibidir.Değişen hiç bir şey yok eğer isterseniz Projeyi İNDİR kısmından alıp bakabilirsiniz.

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.Windows.Forms;

namespace HalıSaha_Takip
{
public partial class Form1 : Form
{
public Form2 frm2;
public Form3 frm3;

public Form1()
{
InitializeComponent();
frm2 = new Form2();
frm3 = new Form3();

frm2.frm1 = this;
frm3.frm1 = this;

}

public OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Jet.Oledb.4.0;Data Source=data.mdb");
public OleDbCommand kmt = new OleDbCommand();
public OleDbDataAdapter adtr = new OleDbDataAdapter();
public DataSet dtst = new DataSet();
public Boolean durum = false;

public void listele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("Select * From musbilg",bag);
adtr.Fill(dtst, "musbilg");
frm3.dataView1.Table = dtst.Tables[0];
frm3.dataGrid1.DataSource = frm3.dataView1;
adtr.Dispose();
bag.Close();
}

public void combo()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * From bos";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
frm2.comboBox1.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
frm2.comboBox1.Sorted = true;
}
public void combo2()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * From dolu";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
frm3.comboBox1.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
frm3.comboBox1.Sorted = true;
}
public void sahayaz2()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from musbilg";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{

switch (oku[5].ToString())
{
case "Pztsi 8-9":
{
button1.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button1.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button1.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 9-10":
{
button2.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button2.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button2.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 10-11":
{
button3.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button3.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button3.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 11-12":
{
button4.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button4.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button4.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 12-13":
{
button5.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button5.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button5.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 13-14":
{
button6.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button6.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button6.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 14-15":
{
button7.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button7.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button7.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 15-16":
{
button8.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button8.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button8.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 16-17":
{
button9.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button9.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button9.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 17-18":
{
button10.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button10.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button10.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 18-19":
{
button11.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button11.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button11.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 19-20":
{
button12.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button12.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button12.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 20-21":
{
button13.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button13.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button13.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 21-22":
{
button14.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button14.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button14.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 22-23":
{
button15.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button15.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button15.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 23-24":
{
button16.Text = oku[1].ToString();
if (oku[0].ToString() == "Abone")
{
button16.BackColor = System.Drawing.Color.Yellow;
break;
}
else
{

button16.BackColor = System.Drawing.Color.Red;
break;
}
}

public void sahayaz1()
{
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select * from musbilg";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
if (frm2.radioButton2.Checked == true)

switch (oku[5].ToString())
{
case "Pztsi 8-9":
{

button1.Text = oku[1].ToString();
if (button1.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button1.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 9-10":
{
button2.Text = oku[1].ToString();
if (button2.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button2.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 10-11":
{
button3.Text = oku[1].ToString();
if (button3.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button3.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 11-12":
{
button4.Text = oku[1].ToString();
if (button4.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button4.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 12-13":
{
button5.Text = oku[1].ToString();
if (button5.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button5.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 13-14":
{
button6.Text = oku[1].ToString();
if (button6.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button6.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 14-15":
{
button7.Text = oku[1].ToString();
if (button7.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button7.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 15-16":
{
button8.Text = oku[1].ToString();
if (button8.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button8.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 16-17":
{
button9.Text = oku[1].ToString();
if (button9.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button9.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 17-18":
{
button10.Text = oku[1].ToString();
if (button10.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button10.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 18-19":
{
button11.Text = oku[1].ToString();
if (button11.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button11.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 19-20":
{
button12.Text = oku[1].ToString();
if (button12.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button12.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 20-21":
{
button13.Text = oku[1].ToString();
if (button13.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button13.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 21-22":
{
button14.Text = oku[1].ToString();
if (button14.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button14.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 22-23":
{
button15.Text = oku[1].ToString();
if (button15.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button15.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Pztsi 23-24":
{
button16.Text = oku[1].ToString();
if (button16.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button16.BackColor = System.Drawing.Color.Red;
break;
}
}

case "Salı 8-9":
{
button17.Text = oku[1].ToString();
if (button17.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button17.BackColor = System.Drawing.Color.Red;
break;
}
}
case "Salı 9-10":
{
button18.Text = oku[1].ToString();
if (button18.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button18.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Salı 10-11":
{
button19.Text = oku[1].ToString();
if (button19.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button19.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Salı 11-12":
{
button20.Text = oku[1].ToString();
if (button20.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button20.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Salı 12-13":
{
button21.Text = oku[1].ToString();
if (button21.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button21.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Salı 13-14":
{
button22.Text = oku[1].ToString();
if (button22.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button22.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Salı 14-15":
{
button23.Text = oku[1].ToString();
if (button23.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button23.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Salı 15-16":
{
button24.Text = oku[1].ToString();
if (button24.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button24.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Salı 16-17":
{
button25.Text = oku[1].ToString();
if (button25.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button25.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Salı 17-18":
{
button26.Text = oku[1].ToString();
if (button26.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button26.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Salı 18-19":
{
button27.Text = oku[1].ToString();
if (button27.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button27.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Salı 19-20":
{
button28.Text = oku[1].ToString();
if (button28.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button28.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Salı 20-21":
{
button29.Text = oku[1].ToString();
if (button29.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button29.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Salı 21-22":
{
button30.Text = oku[1].ToString();
if (button30.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button30.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Salı 22-23":
{
button31.Text = oku[1].ToString();
if (button31.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button31.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Salı 23-24":
{
button32.Text = oku[1].ToString();
if (button32.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button32.BackColor = System.Drawing.Color.Red;
}
break;
}

case "Çrş 8-9":
{
button33.Text = oku[1].ToString();
if (button33.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button33.BackColor = System.Drawing.Color.Red;
}
break;
}

case "Çrş 9-10":
{
button34.Text = oku[1].ToString();
if (button34.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button34.BackColor = System.Drawing.Color.Red;
}
break;
}

case "Çrş 10-11":
{
button35.Text = oku[1].ToString();
if (button35.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button35.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Çrş 11-12":
{
button36.Text = oku[1].ToString();
if (button36.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button36.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Çrş 12-13":
{
button37.Text = oku[1].ToString();
if (button37.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button37.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Çrş 13-14":
{
button38.Text = oku[1].ToString();
if (button38.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button38.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Çrş 14-15":
{
button39.Text = oku[1].ToString();
if (button39.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button39.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Çrş 15-16":
{
button40.Text = oku[1].ToString();
if (button40.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button40.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Çrş 16-17":
{
button41.Text = oku[1].ToString();
if (button41.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button41.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Çrş 17-18":
{
button42.Text = oku[1].ToString();
if (button42.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button42.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Çrş 18-19":
{
button43.Text = oku[1].ToString();
if (button43.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button43.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Çrş 19-20":
{
button44.Text = oku[1].ToString();
if (button44.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button44.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Çrş 20-21":
{
button45.Text = oku[1].ToString();
if (button45.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button45.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Çrş 21-22":
{
button46.Text = oku[1].ToString();
if (button46.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button46.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Çrş 22-23":
{
button47.Text = oku[1].ToString();
if (button47.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button47.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Çrş 23-24":
{
button48.Text = oku[1].ToString();
if (button48.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button48.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 8-9":
{
button49.Text = oku[1].ToString();
if (button49.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button49.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 9-10":
{
button50.Text = oku[1].ToString();
if (button50.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button50.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 10-11":
{
button51.Text = oku[1].ToString();
if (button51.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button51.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 11-12":
{
button52.Text = oku[1].ToString();
if (button52.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button52.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 12-13":
{
button53.Text = oku[1].ToString();
if (button53.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button53.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 13-14":
{
button54.Text = oku[1].ToString();
if (button54.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button54.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 14-15":
{
button55.Text = oku[1].ToString();
if (button55.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button55.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 15-16":
{
button56.Text = oku[1].ToString();
if (button56.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button56.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 16-17":
{
button57.Text = oku[1].ToString();
if (button57.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button57.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 17-18":
{
button58.Text = oku[1].ToString();
if (button58.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button58.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 18-19":
{
button59.Text = oku[1].ToString();
if (button59.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button59.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 19-20":
{
button60.Text = oku[1].ToString();
if (button60.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button60.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 20-21":
{
button61.Text = oku[1].ToString();
if (button61.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button61.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 21-22":
{
button62.Text = oku[1].ToString();
if (button62.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button62.BackColor = System.Drawing.Color.Red;
}
break;
}

case "Prş 22-23":
{
button63.Text = oku[1].ToString();
if (button63.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button63.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Prş 23-24":
{
button64.Text = oku[1].ToString();
if (button64.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button64.BackColor = System.Drawing.Color.Red;
}
break;
}

case "Cuma 8-9":
{
button65.Text = oku[1].ToString();
if (button65.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button65.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 9-10":
{
button66.Text = oku[1].ToString();
if (button66.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button66.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 10-11":
{
button67.Text = oku[1].ToString();
if (button67.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button67.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 11-12":
{
button68.Text = oku[1].ToString();
if (button68.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button68.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 12-13":
{
button69.Text = oku[1].ToString();
if (button69.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button69.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 13-14":
{
button70.Text = oku[1].ToString();
if (button70.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button70.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 14-15":
{
button71.Text = oku[1].ToString();
if (button71.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button71.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 15-16":
{
button72.Text = oku[1].ToString();
if (button72.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button72.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 16-17":
{
button73.Text = oku[1].ToString();
if (button73.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button73.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 17-18":
{
button74.Text = oku[1].ToString();
if (button74.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button74.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 18-19":
{
button75.Text = oku[1].ToString();
if (button75.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button75.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 19-20":
{
button76.Text = oku[1].ToString();
if (button76.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button76.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 20-21":
{
button77.Text = oku[1].ToString();
if (button77.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button77.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 21-22":
{
button78.Text = oku[1].ToString();
if (button78.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button78.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 22-23":
{
button79.Text = oku[1].ToString();
if (button79.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button79.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Cuma 23-24":
{
button80.Text = oku[1].ToString();
if (button80.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button80.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 8-9":
{
button81.Text = oku[1].ToString();
if (button81.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button81.BackColor = System.Drawing.Color.Red;
}
break;
}

case "Ctsi 9-10":
{
button82.Text = oku[1].ToString();
if (button82.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button82.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 10-11":
{
button83.Text = oku[1].ToString();
if (button83.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button83.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 11-12":
{
button84.Text = oku[1].ToString();
if (button84.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button84.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 12-13":
{
button85.Text = oku[1].ToString();
if (button85.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button85.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 13-14":
{
button86.Text = oku[1].ToString();
if (button86.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button86.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 14-15":
{
button87.Text = oku[1].ToString();
if (button87.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button87.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 15-16":
{
button88.Text = oku[1].ToString();
if (button88.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button88.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 16-17":
{
button89.Text = oku[1].ToString();
if (button89.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button89.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 17-18":
{
button90.Text = oku[1].ToString();
if (button90.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button90.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 18-19":
{
button91.Text = oku[1].ToString();
if (button91.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button91.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 19-20":
{
button92.Text = oku[1].ToString();
if (button92.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button92.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 20-21":
{
button93.Text = oku[1].ToString();
if (button93.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button93.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 21-22":
{
button94.Text = oku[1].ToString();
if (button94.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button94.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 22-23":
{
button95.Text = oku[1].ToString();
if (button95.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button95.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Ctsi 23-24":
{
button96.Text = oku[1].ToString();
if (button96.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button96.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 8-9":
{
button97.Text = oku[1].ToString();
if (button97.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button97.BackColor = System.Drawing.Color.Red;
}
break;
}

case "Pzr 9-10":
{
button98.Text = oku[1].ToString();
if (button98.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button98.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 10-11":
{
button99.Text = oku[1].ToString();
if (button99.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button99.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 11-12":
{
button100.Text = oku[1].ToString();
if (button100.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button100.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 12-13":
{
button101.Text = oku[1].ToString();
if (button101.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button101.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 13-14":
{
button102.Text = oku[1].ToString();
if (button102.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button102.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 14-15":
{
button103.Text = oku[1].ToString();
if (button103.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button103.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 15-16":
{
button104.Text = oku[1].ToString();
if (button104.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button104.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 16-17":
{
button105.Text = oku[1].ToString();
if (button105.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button105.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 17-18":
{
button106.Text = oku[1].ToString();
if (button106.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button106.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 18-19":
{
button107.Text = oku[1].ToString();
if (button107.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button107.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 19-20":
{
button108.Text = oku[1].ToString();
if (button108.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button108.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 20-21":
{
button109.Text = oku[1].ToString();
if (button109.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button109.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 21-22":
{
button110.Text = oku[1].ToString();
if (button110.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button110.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 22-23":
{
button111.Text = oku[1].ToString();
if (button111.BackColor == System.Drawing.Color.Yellow)
{
break;
}
else
{
button111.BackColor = System.Drawing.Color.Red;
}
break;
}
case "Pzr 23-24":
{
button112.Text = oku[1].ToString();
if (button112.BackColor == System.Drawing.Color.Yellow)
{
break;
}
{
button112.BackColor = System.Drawing.Color.Red;
}
break;
}

}
}

bag.Close();
oku.Dispose();
}

public void sahasil()
{
switch (frm3.comboBox1.Text)
{
case "Pztsi 8-9":
{
button1.Text = "Pztsi 8-9";
button1.BackColor = System.Drawing.Color.Green;
break;
}

case "Pztsi 9-10":
{
button2.Text = "Pztsi 9-10";
button2.BackColor = System.Drawing.Color.Green;
break;
}
case "Pztsi 10-11":
{
button3.Text = "Pztsi 10-11";
button3.BackColor = System.Drawing.Color.Green;
break;
}
case "Pztsi 11-12":
{
button4.Text = "Pztsi 11-12";
button4.BackColor = System.Drawing.Color.Green;
break;
}
case "Pztsi 12-13":
{
button5.Text = "Pztsi 12-13";
button5.BackColor = System.Drawing.Color.Green;
break;
}
case "Pztsi 13-14":
{
button6.Text = "Pztsi 13-14";
button6.BackColor = System.Drawing.Color.Green;
break;
}
case "Pztsi 14-15":
{
button7.Text = "Pztsi 14-15";
button7.BackColor = System.Drawing.Color.Green;
break;
}
case "Pztsi 15-16":
{
button8.Text = "Pztsi 15-16";
button8.BackColor = System.Drawing.Color.Green;
break;
}
case "Pztsi 16-17":
{
button9.Text = "Pztsi 16-17";
button9.BackColor = System.Drawing.Color.Green;
break;
}
case "Pztsi 17-18":
{
button10.Text = "Pztsi 17-18";
button10.BackColor = System.Drawing.Color.Green;
break;
}
case "Pztsi 18-19":
{
button11.Text = "Pztsi 18-19";
button11.BackColor = System.Drawing.Color.Green;
break;
}
case "Pztsi 19-20":
{
button12.Text = "Pztsi 19-20";
button12.BackColor = System.Drawing.Color.Green;
break;
}
case "Pztsi 20-21":
{
button13.Text = "Pztsi 20-21";
button13.BackColor = System.Drawing.Color.Green;
break;
}
case "Pztsi 21-22":
{
button14.Text = "Pztsi 21-22";
button14.BackColor = System.Drawing.Color.Green;
break;
}
case "Pztsi 22-23":
{
button15.Text = "Pztsi 22-23";
button15.BackColor = System.Drawing.Color.Green;
break;
}
case "Pztsi 23-24":
{
button16.Text = "Pztsi 23-24";
button16.BackColor = System.Drawing.Color.Green;
break;
}

case "Salı 8-9":
{
button17.Text = "Salı 8-9";
button17.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 9-10":
{
button18.Text = "Salı 9-10";
button18.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 10-11":
{
button19.Text = "Salı 10-11";
button19.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 11-12":
{
button20.Text = "Salı 11-12";
button20.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 12-13":
{
button21.Text = "Salı 12-13";
button21.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 13-14":
{
button22.Text = "Salı 13-14";
button22.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 14-15":
{
button23.Text = "Salı 14-15";
button23.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 15-16":
{
button24.Text = "Salı 15-16";
button24.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 16-17":
{
button25.Text = "Salı 16-17";
button25.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 17-18":
{
button26.Text = "Salı 17-18";
button26.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 18-19":
{
button27.Text = "Salı 18-19";
button27.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 19-20":
{
button28.Text = "Salı 19-20";
button28.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 20-21":
{
button29.Text = "Salı 20-21";
button29.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 21-22":
{
button30.Text = "Salı 21-22";
button30.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 22-23":
{
button31.Text = "Salı 22-23";
button31.BackColor = System.Drawing.Color.Green;
break;
}
case "Salı 23-24":
{
button32.Text = "Salı 23-24";
button32.BackColor = System.Drawing.Color.Green;
break;
}

case "Çrş 8-9":
{
button33.Text = "Çrş 8-9";
button33.BackColor = System.Drawing.Color.Green;
break;
}

case "Çrş 9-10":
{
button34.Text = "Çrş 9-10";
button34.BackColor = System.Drawing.Color.Green;
break;
}
case "Çrş 10-11":
{
button35.Text = "Çrş 10-11";
button35.BackColor = System.Drawing.Color.Green;
break;
}
case "Çrş 11-12":
{
button36.Text = "Çrş 11-12";
button36.BackColor = System.Drawing.Color.Green;
break;
}
case "Çrş 12-13":
{
button37.Text = "Çrş 12-13";
button37.BackColor = System.Drawing.Color.Green;
break;
}
case "Çrş 13-14":
{
button38.Text = "Çrş 13-14";
button38.BackColor = System.Drawing.Color.Green;
break;
}
case "Çrş 14-15":
{
button39.Text = "Çrş 14-15";
button39.BackColor = System.Drawing.Color.Green;
break;
}
case "Çrş 15-16":
{
button40.Text = "Çrş 15-16";
button40.BackColor = System.Drawing.Color.Green;
break;
}
case "Çrş 16-17":
{
button41.Text = "Çrş 16-17";
button41.BackColor = System.Drawing.Color.Green;
break;
}
case "Çrş 17-18":
{
button42.Text = "Çrş 17-18";
button42.BackColor = System.Drawing.Color.Green;
break;
}
case "Çrş 18-19":
{
button43.Text = "Çrş 18-19";
button43.BackColor = System.Drawing.Color.Green;
break;
}
case "Çrş 19-20":
{
button44.Text = "Çrş 19-20";
button44.BackColor = System.Drawing.Color.Green;
break;
}
case "Çrş 20-21":
{
button45.Text = "Çrş 20-21";
button45.BackColor = System.Drawing.Color.Green;
break;
}
case "Çrş 21-22":
{
button46.Text = "Çrş 21-22";
button46.BackColor = System.Drawing.Color.Green;
break;
}
case "Çrş 22-23":
{
button47.Text = "Çrş 22-23";
button47.BackColor = System.Drawing.Color.Green;
break;
}
case "Çrş 23-24":
{
button48.Text = "Çrş 23-24";
button48.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 8-9":
{
button49.Text = "Prş 8-9";
button49.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 9-10":
{
button50.Text = "Prş 9-10";
button50.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 10-11":
{
button51.Text = "Prş 10-11";
button51.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 11-12":
{
button52.Text = "Prş 11-12";
button52.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 12-13":
{
button53.Text = "Prş 12-13";
button53.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 13-14":
{
button54.Text = "Prş 13-14";
button54.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 14-15":
{
button55.Text = "Prş 14-15";
button55.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 15-16":
{
button56.Text = "Prş 15-16";
button56.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 16-17":
{
button57.Text = "Prş 16-17";
button57.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 17-18":
{
button58.Text = "Prş 17-18";
button58.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 18-19":
{
button59.Text = "Prş 18-19";
button59.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 19-20":
{
button60.Text = "Prş 19-20";
button60.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 20-21":
{
button61.Text = "Prş 20-21";
button61.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 21-22":
{
button62.Text = "Prş 21-22";
button62.BackColor = System.Drawing.Color.Green;
break;
}

case "Prş 22-23":
{
button63.Text = "Prş 22-23";
button63.BackColor = System.Drawing.Color.Green;
break;
}
case "Prş 23-24":
{
button64.Text = "Prş 23-24";
button64.BackColor = System.Drawing.Color.Green;
break;
}

case "Cuma 8-9":
{
button65.Text = "Cuma 8-9";
button65.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 9-10":
{
button66.Text = "Cuma 9-10";
button66.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 10-11":
{
button67.Text = "Cuma 10-11";
button67.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 11-12":
{
button68.Text = "Cuma 11-12";
button68.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 12-13":
{
button69.Text = "Cuma 12-13";
button69.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 13-14":
{
button70.Text = "Cuma 13-14";
button70.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 14-15":
{
button71.Text = "Cuma 14-15";
button71.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 15-16":
{
button72.Text = "Cuma 15-16";
button72.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 16-17":
{
button73.Text = "Cuma 16-17";
button73.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 17-18":
{
button74.Text = "Cuma 17-18";
button74.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 18-19":
{
button75.Text = "Cuma 18-19";
button75.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 19-20":
{
button76.Text = "Cuma 19-20";
button76.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 20-21":
{
button77.Text = "Cuma 20-21";
button77.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 21-22":
{
button78.Text = "Cuma 21-22";
button78.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 22-23":
{
button79.Text = "Cuma 22-23";
button79.BackColor = System.Drawing.Color.Green;
break;
}
case "Cuma 23-24":
{
button80.Text = "Cuma 23-24";
button80.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 8-9":
{
button81.Text = "Ctsi 8-9";
button81.BackColor = System.Drawing.Color.Green;
break;
}

case "Ctsi 9-10":
{
button82.Text = "Ctsi 9-10";
button82.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 10-11":
{
button83.Text = "Ctsi 10-11";
button83.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 11-12":
{
button84.Text = "Ctsi 11-12";
button84.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 12-13":
{
button85.Text = "Ctsi 12-13";
button85.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 13-14":
{
button86.Text = "Ctsi 13-14";
button86.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 14-15":
{
button87.Text = "Ctsi 14-15";
button87.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 15-16":
{
button88.Text = "Ctsi 15-16";
button88.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 16-17":
{
button89.Text = "Ctsi 16-17";
button89.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 17-18":
{
button90.Text = "Ctsi 17-18";
button90.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 18-19":
{
button91.Text = "Ctsi 18-19";
button91.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 19-20":
{
button92.Text = "Ctsi 19-20";
button92.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 20-21":
{
button93.Text = "Ctsi 20-21";
button93.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 21-22":
{
button94.Text = "Ctsi 21-22";
button94.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 22-23":
{
button95.Text = "Ctsi 22-23";
button95.BackColor = System.Drawing.Color.Green;
break;
}
case "Ctsi 23-24":
{
button96.Text = "Ctsi 23-24";
button96.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 8-9":
{
button97.Text = "Pzr 8-9";
button97.BackColor = System.Drawing.Color.Green;
break;
}

case "Pzr 9-10":
{
button98.Text = "Pzr 9-10";
button98.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 10-11":
{
button99.Text = "Pzr 10-11";
button99.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 11-12":
{
button100.Text = "Pzr 11-12";
button100.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 12-13":
{
button101.Text = "Pzr 12-13";
button101.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 13-14":
{
button102.Text = "Pzr 13-14";
button102.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 14-15":
{
button103.Text = "Pzr 14-15";
button103.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 15-16":
{
button104.Text = "Pzr 15-16";
button104.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 16-17":
{
button105.Text = "Pzr 16-17";
button105.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 17-18":
{
button106.Text = "Pzr 17-18";
button106.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 18-19":
{
button107.Text = "Pzr 18-19";
button107.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 19-20":
{
button108.Text = "Pzr 19-20";
button108.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 20-21":
{
button109.Text = "Pzr 20-21";
button109.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 21-22":
{
button110.Text = "Pzr 21-22";
button110.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 22-23":
{
button111.Text = "Pzr 22-23";
button111.BackColor = System.Drawing.Color.Green;
break;
}
case "Pzr 23-24":
{
button112.Text = "Pzr 23-24";
button112.BackColor = System.Drawing.Color.Green;
break;
}

}
}

private void Form1_Load(object sender, EventArgs e)
{
sahayaz2();
sahayaz();
sahayaz1();

}

private void button115_Click(object sender, EventArgs e)
{
frm3.ShowDialog();
}

private void button113_Click_1(object sender, EventArgs e)
{
Application.Exit();
}

private void button114_Click(object sender, EventArgs e)
{
frm2.ShowDialog();

}
}
}

[/code]

FORM2 İçerisine Yazılacak Kodlar…

[code language=”CSharp”]
public partial class Form2 : Form
{
public Form1 frm1;
public Form2()
{
InitializeComponent();
}

private void Form2_Load(object sender, EventArgs e)
{
frm1.combo();
}

private void button2_Click(object sender, EventArgs e)
{
this.Close();
}

private void button1_Click(object sender, EventArgs e)
{
if (radioButton1.Checked == true)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO musbilg(Sahatutmaislemi,Ad,Soyad,Telefon,KimlikNo,GünSaat) VALUES (‘"+radioButton1.Text+"’,’" + textBox1.Text + "’,’" + textBox2.Text + "’,’" + maskedTextBox1.Text + "’,’" + textBox4.Text + "’,’" + comboBox1.Text + "’)";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "INSERT INTO dolu(DoluSaatler)VALUES (‘" + comboBox1.Text + "’)";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE From bos WHERE BosSaatler=’" + comboBox1.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
textBox1.Clear(); textBox2.Clear(); maskedTextBox1.Clear(); textBox4.Clear();
comboBox1.Text = "";
frm1.combo();
frm1.sahayaz();

MessageBox.Show("Kayıt İşlemi TamamLandı");

}

if (radioButton2.Checked == true)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO musbilg(Sahatutmaislemi,Ad,Soyad,Telefon,KimlikNo,GünSaat) VALUES (‘" + radioButton2.Text + "’,’" + textBox1.Text + "’,’" + textBox2.Text + "’,’" + maskedTextBox1.Text + "’,’" + textBox4.Text + "’,’" + comboBox1.Text + "’)";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "INSERT INTO dolu(DoluSaatler)VALUES (‘" + comboBox1.Text + "’)";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE From bos WHERE BosSaatler=’" + comboBox1.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
textBox1.Clear(); textBox2.Clear(); maskedTextBox1.Clear(); textBox4.Clear();
comboBox1.Text = "";
frm1.combo();
frm1.sahayaz1();

MessageBox.Show("Kayıt İşlemi TamamLandı");

}
}
private void textBox4_Leave(object sender, EventArgs e)
{
if (textBox4.Text.Length != 11)
{
MessageBox.Show("Lütfen 11 Haneli Giriniz");
}

}

private void textBox1_KeyPress(object sender, KeyPressEventArgs e)
{
if (char.IsLetter(e.KeyChar) == false &&
char.IsWhiteSpace(e.KeyChar) == false && e.KeyChar != (char)08)
e.Handled = true;
}

private void textBox2_KeyPress(object sender, KeyPressEventArgs e)
{
if (char.IsLetter(e.KeyChar) == false &&
char.IsWhiteSpace(e.KeyChar) == false && e.KeyChar != (char)08)
e.Handled = true;
}

private void textBox1_Leave(object sender, EventArgs e)
{
string ad;
ad = textBox1.Text;
textBox1.Text = ad.ToUpper();
}

private void textBox2_Leave(object sender, EventArgs e)
{
string soyad;
soyad = textBox2.Text;
textBox2.Text = soyad.ToUpper();
}

}
[/code]

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

FORM3 İç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.Windows.Forms;

namespace HalıSaha_Takip
{
public partial class Form3 : Form
{
public Form1 frm1;
public Form3()
{
InitializeComponent();
}
void texteyaz()
{
textBox2.Text = (this.BindingContext[frm1.dtst, "musbilg"].Position + 1) + " / " + this.BindingContext[frm1.dtst, "musbilg"].Count;
}

private void Form3_Load(object sender, EventArgs e)
{
frm1.combo2();
frm1.listele();
textBox3.DataBindings.Add("Text", frm1.dtst, "musbilg.Ad");
textBox4.DataBindings.Add("Text", frm1.dtst, "musbilg.Soyad");
maskedTextBox1.DataBindings.Add("Text", frm1.dtst, "musbilg.Telefon");
textBox6.DataBindings.Add("Text", frm1.dtst, "musbilg.KimlikNo");
comboBox1.DataBindings.Add("Text", frm1.dtst, "musbilg.GünSaat");
texteyaz();

}

private void button2_Click(object sender, EventArgs e)
{

}

private void button2_Click_1(object sender, EventArgs e)
{
this.Close();
}

private void button1_Click(object sender, EventArgs e)
{
DialogResult cevap;
cevap = MessageBox.Show("Kaydı Silmek İstediğinizden Eminmisiniz?", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
frm1.sahasil();
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "DELETE from musbilg WHERE Ad=’" + textBox3.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "INSERT INTO bos(BosSaatler) VALUES (‘" + comboBox1.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.CommandText = "DELETE from dolu WHERE DoluSaatler=’" + comboBox1.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
comboBox1.Items.Clear();
frm1.frm2.comboBox1.Items.Clear();
comboBox1.Text = "";
frm1.combo();
frm1.combo2();
frm1.dtst.Clear();
frm1.listele();
}

}

private void textBox1_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From musbilg", frm1.bag);
if (textBox1.Text == "")
{
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "Select * from musbilg";
adtr.SelectCommand = frm1.kmt;
adtr.Fill(frm1.dtst, "musbilg");
}
if (Convert.ToBoolean(frm1.bag.State) == false)
{
frm1.bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From musbilg" +
" where(Ad like ‘%" + textBox1.Text + "%’ )";
frm1.dtst.Tables["musbilg"].Clear();
adtr.Fill(frm1.dtst, "musbilg");
frm1.bag.Close();
}

private void textBox2_TextChanged(object sender, EventArgs e)
{

}

private void button3_Click(object sender, EventArgs e)
{
this.BindingContext[frm1.dtst, "musbilg"].Position += 1;
texteyaz();
}

private void button5_Click(object sender, EventArgs e)
{
this.BindingContext[frm1.dtst, "musbilg"].Position -= 1;
texteyaz();
}

private void button6_Click(object sender, EventArgs e)
{
this.BindingContext[frm1.dtst, "musbilg"].Position = 0;
texteyaz();
}

private void button4_Click(object sender, EventArgs e)
{
this.BindingContext[frm1.dtst, "musbilg"].Position = this.BindingContext[frm1.dtst, "musbilg"].Count;
texteyaz();
}

private void textBox4_KeyPress(object sender, KeyPressEventArgs e)
{
if (char.IsLetter(e.KeyChar) == false &&
char.IsWhiteSpace(e.KeyChar) == false && e.KeyChar != (char)08)
e.Handled = true;
}

private void textBox3_KeyPress(object sender, KeyPressEventArgs e)
{
if (char.IsLetter(e.KeyChar) == false &&
char.IsWhiteSpace(e.KeyChar) == false && e.KeyChar != (char)08)
e.Handled = true;
}

private void textBox3_Leave(object sender, EventArgs e)
{
string ad;
ad = textBox3.Text;
textBox3.Text = ad.ToUpper();
}

private void textBox4_Leave(object sender, EventArgs e)
{
string soyad;
soyad = textBox4.Text;
textBox4.Text = soyad.ToUpper();
}
}
}

[/code]

Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.

Projeyi İNDİR

Yorumlar 18

  • bu proğramı nasıl kuracağız kardeş projeyi indirdim şimdi ne yapıcanm bu kodları tek tek elle girmemmi gerek girmek gerekiyorsa ondan sonra program nasıl kurulacak bi yardım et biladerim

  • Microsoft Visual Studio 2008 veya üst versiyon kurulu bir makinede çalıştırabilirsin.

  • kardeş nasıl kuracağız anlata bilirmisin

  • ya kardeşim paylaşım için tşk ederim ama dataView1 onu nasıl koydun anlamadım biraz bahseder misin acaba ben yapamıyorum onu projem bu yardımcı olursan sevinirim…:)

  • muharrem:
    toolbox sağ tıkla — Choose Item Tıkla — Gelen Menüden DataView’i Seç

  • ayvallah kardeşim çok saol Allah razı olsun 🙂

  • aleykümselam arkadaşlar ilk önce bu programı yazanın ellerine sağlık şimdiden sükramlarımı belirtmek isterim bunu yazan arkadaşa bir sorum olacak yukarıya koydukları tarihleri her pazara geldiğinde değişsin istiyorum hemde aylara göre istinasları oluyor mesela şubat bir 28 bir 29 cekiyor bazı aylarda 30 ve 31 çekiyor o tarihleri nasıl ayarlayabilirim bu konuda bana acıliyeti var yardımlarınızı bekliyorum teşekkür ederim.

  • datetime metodu ile günü yani pazarı elde edeceksin.if ile pazar ise sıfırlayacaksın.

  • Benim proje ödevim veritabanı konusunda yardımcı olur musunuz?

  • bu programı yapan arkadaş Programı SQL olarak atabilirmi atarsa çok iyi olur.

  • bilgisayarda visual studio ve SQL var ama bu programı indirdiğimde açılmadı nasıl yapmalıyım

  • Özgür :
    Projeler için gorselprogram@gmail.com a mail atınız.

  • Özgür :
    Proje sql veri tabanlı değil Access veri tabanlı.
    Access dosyası bin-debug klasöründe.

  • Tamam teşekürler

  • Halı saha otomasyon projesini SQL tabanlı yapmam lazım (okul ödevim)
    bana yardım edermisin?

  • özgür :
    Projeler için gorselprogram@gmail.com a mail atınız

  • @Özgür
    özgür projeyi yapabildin mi? c# asp.net core mvc ile mssql veri tabanlı hazırlanan halı saha otomasyonu proje ödevim

  • @beyza
    asıl sen yapabildin mi aynısı benim de ödevim 😀

Bir yanıt yazın

E-posta adresiniz yayınlanmayacak. Gerekli alanlar * ile işaretlenmişlerdir