Spor Salonu Takip – Csharp

AnaSayfa

[code lang=”csharp”]

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Data.OleDb;

namespace Spor_Salonu_Takip

{

public partial class Form1 : Form

{

public frmBilgiGüncelle frmbilgiGuncelle;

public frmEkle frmEkle;

public frmBilgi frmBilgi;

public frmGuncelle frmGuncelle;

public Form1()

{

InitializeComponent();

frmEkle = new frmEkle();

frmbilgiGuncelle = new frmBilgiGüncelle();

frmGuncelle=new frmGuncelle();

frmBilgi = new frmBilgi();

frmGuncelle.frm1 = this;

frmbilgiGuncelle.frm1 = this;

frmEkle.frm1 = this;

frmBilgi.frm1 = this;

}

OleDbConnection baglanti = new OleDbConnection("Provider=Microsoft.ace.OleDb.12.0;Data source=data.accdb");

public void yenile()

{

DataTable tablo = new DataTable();

OleDbDataAdapter adaptör = new OleDbDataAdapter("select Kisi_no,Kisi_ad,Kisi_soyad,Kisi_telno,Kisi_cinsiyet,Kisi_adres from Kisiler", baglanti);

adaptör.Fill(tablo);

dataGridView1.DataSource = tablo;

}

private void Form1_Load(object sender, EventArgs e)

{

yenile();

dataGridView1.Columns[0].HeaderText = "No";

dataGridView1.Columns[1].HeaderText="Adı";

dataGridView1.Columns[2].HeaderText="Soyadı";

dataGridView1.Columns[3].HeaderText="Tel No";

dataGridView1.Columns[4].HeaderText="Cinsiyet";

dataGridView1.Columns[5].HeaderText="Adres";

dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;

}

private void btn_Ekle_Click(object sender, EventArgs e)

{

frmEkle.ShowDialog();

}

private void btn_Sil_Click(object sender, EventArgs e)

{

DialogResult silsinmi = MessageBox.Show("Seçilen Kişi Silinsinmi ?","Uyarı",MessageBoxButtons.YesNo,MessageBoxIcon.Question);

if (silsinmi == DialogResult.Yes)

{

OleDbCommand kmtSil = new OleDbCommand();

baglanti.Open();

kmtSil.Connection = baglanti;

kmtSil.CommandText = "DELETE FROM Kisiler where Kisi_no=" + dataGridView1.CurrentRow.Cells[0].Value.ToString() + "";

kmtSil.ExecuteNonQuery();

baglanti.Close();

yenile();

}

}

private void btn_Guncelle_Click(object sender, EventArgs e)

{

frmGuncelle.txt_Ad.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();

frmGuncelle.txt_Soyad.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString();

frmGuncelle.txt_Tel.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString();

frmGuncelle.cmb_Cinsiyet.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString();

frmGuncelle.txt_Adres.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString();

frmGuncelle.ShowDialog();

}

private void btn_Ara_Click(object sender, EventArgs e)

{

frmAra frmAra = new frmAra();

frmAra.ShowDialog();

}

private void button1_Click(object sender, EventArgs e)

{

frmBilgi.ShowDialog();

}

}

}
[/code]

Arama

[code lang=”csharp”]

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Data.OleDb;

namespace Spor_Salonu_Takip

{

public partial class frmAra : Form

{

public frmAra()

{

InitializeComponent();

}

OleDbConnection baglanti = new OleDbConnection("provider=microsoft.ace.oledb.12.0;data source=data.accdb");

private void txtAra_TextChanged(object sender, EventArgs e)

{

DataTable tablo = new DataTable();

OleDbDataAdapter adaptör = new OleDbDataAdapter("select * from Kisiler where Kisi_ad Like ‘%"+txtAra.Text+"%’",baglanti);

adaptör.Fill(tablo);

dataGridView1.DataSource = tablo;

}

private void frmAra_Load(object sender, EventArgs e)

{

DataTable tablo = new DataTable();

OleDbDataAdapter adaptör = new OleDbDataAdapter("select * from Kisiler", baglanti);

adaptör.Fill(tablo);

dataGridView1.DataSource = tablo;

dataGridView1.Columns[0].HeaderText = "No";

dataGridView1.Columns[1].HeaderText = "Adı";

dataGridView1.Columns[2].HeaderText = "Soyadı";

dataGridView1.Columns[3].HeaderText = "Tel No";

dataGridView1.Columns[4].HeaderText = "Cinsiyet";

dataGridView1.Columns[5].HeaderText = "Adres";

}

}

}

[/code]

Beden Bilgi Güncelle

[code lang=”csharp”]
using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Data.OleDb;

namespace Spor_Salonu_Takip

{

public partial class frmBilgi : Form

{

public Form1 frm1;

public frmBilgi()

{

InitializeComponent();

}

OleDbConnection baglanti = new OleDbConnection("provider=microsoft.ace.oledb.12.0;data source=data.accdb");

private void frmBilgi_Load(object sender, EventArgs e)

{

DataTable tablo = new DataTable();

OleDbDataAdapter adaptör = new OleDbDataAdapter("select Kilo,Boy,Göbek,Kol,Bacak from Kisiler where Kisi_no=" + frm1.dataGridView1.CurrentRow.Cells[0].Value.ToString() + "", baglanti);

adaptör.Fill(tablo);

dataGridView1.DataSource = tablo;

label1.Text = frm1.dataGridView1.CurrentRow.Cells[1].Value.ToString() +" "+ frm1.dataGridView1.CurrentRow.Cells[2].Value.ToString()+" Adlı Müşterimizin Vücut Bilgileri";

}

private void btn_Guncelle_Click(object sender, EventArgs e)

{

frm1.frmbilgiGuncelle.ShowDialog();

}

}

}
[/code]

Vücut Bilgileri

[code lang=”csharp”]
using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Data.OleDb;

namespace Spor_Salonu_Takip

{

public partial class frmBilgiGüncelle : Form

{

public Form1 frm1;

public frmBilgiGüncelle()

{

InitializeComponent();

}

OleDbConnection baglanti = new OleDbConnection("Provider=microsoft.ace.oledb.12.0;data source=data.accdb");

private void frmBilgiGüncelle_Load(object sender, EventArgs e)

{

txt_Kilo.Text = frm1.frmBilgi.dataGridView1.CurrentRow.Cells[0].Value.ToString();

txt_Boy.Text = frm1.frmBilgi.dataGridView1.CurrentRow.Cells[1].Value.ToString();

txt_Göbek.Text = frm1.frmBilgi.dataGridView1.CurrentRow.Cells[2].Value.ToString();

txt_Kol.Text = frm1.frmBilgi.dataGridView1.CurrentRow.Cells[3].Value.ToString();

txt_Bacak.Text = frm1.frmBilgi.dataGridView1.CurrentRow.Cells[4].Value.ToString();

}

private void btn_Guncelle_Click(object sender, EventArgs e)

{

if (txt_Kilo.Text.TrimEnd() == "" || txt_Boy.Text.TrimEnd() == "" || txt_Göbek.Text.TrimEnd() == "" || txt_Kol.Text.TrimEnd() == "" || txt_Bacak.Text.TrimEnd() == "") MessageBox.Show("Lütfen Boş Yerleri Doldurunuz", "Uyarı", MessageBoxButtons.OK, MessageBoxIcon.Stop);

else

{

DialogResult guncellesinmi = MessageBox.Show("Veri Güncellensinmi ?", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

if (guncellesinmi == DialogResult.Yes)

{

OleDbCommand kmtGuncel = new OleDbCommand();

baglanti.Open();

kmtGuncel.Connection = baglanti;

kmtGuncel.CommandText = "update Kisiler set Kilo=@kilo,Boy=@boy, Göbek=@göbek,Kol=@kol,Bacak=@bacak where Kisi_no=@anahtar";

kmtGuncel.Parameters.AddWithValue("@kilo", txt_Kilo.Text);

kmtGuncel.Parameters.AddWithValue("@boy", txt_Boy.Text);

kmtGuncel.Parameters.AddWithValue("@göbek", txt_Göbek.Text);

kmtGuncel.Parameters.AddWithValue("@kol", txt_Kol.Text);

kmtGuncel.Parameters.AddWithValue("@bacak", txt_Bacak.Text);

kmtGuncel.Parameters.AddWithValue("@anahtar", frm1.dataGridView1.CurrentRow.Cells[0].Value.ToString());

kmtGuncel.ExecuteNonQuery();

baglanti.Close();

DataTable tablo = new DataTable();

OleDbDataAdapter adaptör = new OleDbDataAdapter("select Kilo,Boy,Göbek,Kol,Bacak from Kisiler", baglanti);

adaptör.Fill(tablo);

frm1.frmBilgi.dataGridView1.DataSource = tablo;

}

}

}

}

}
[/code]

Kişi Ekle

[code lang=”csharp”]
using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Data.OleDb;

namespace Spor_Salonu_Takip

{

public partial class frmEkle : Form

{

public Form1 frm1;

public frmEkle()

{

InitializeComponent();

}

OleDbConnection baglanti = new OleDbConnection("Provider=Microsoft.ace.OleDb.12.0;Data source=data.accdb");

private void btn_Ekle_Click(object sender, EventArgs e)

{

if (txt_Ad.Text.TrimEnd() == "" || txt_Soyad.Text.TrimEnd() == "" || txt_Tel.Text.TrimEnd() == "" || txt_Adres.Text.TrimEnd() == "" || txt_Kilo.Text.TrimEnd() == "" || txt_Boy.Text.TrimEnd() == "" || txt_Göbek.Text.TrimEnd() == "" || txt_Kol.Text.TrimEnd() == "" || txt_Bacak.Text.TrimEnd() == "") MessageBox.Show("Lütfen Boş Yerleri Doldurunuz", "Uyarı", MessageBoxButtons.OK, MessageBoxIcon.Stop);

else if (cmb_Cinsiyet.Text == "Seçiniz")

{

MessageBox.Show("Lütfen Cinsiyetinizi Seçiniz", "Uyarı", MessageBoxButtons.OK, MessageBoxIcon.Warning);

cmb_Cinsiyet.Focus();

}

else

{

OleDbCommand komut = new OleDbCommand();

baglanti.Open();

komut.Connection = baglanti;

komut.CommandText = "INSERT INTO Kisiler(Kisi_ad,Kisi_soyad,Kisi_telno,Kisi_cinsiyet,Kisi_adres,Kilo,Boy,Göbek,Kol,Bacak) values(‘" + txt_Ad.Text + "’,’" + txt_Soyad.Text + "’,’" + txt_Tel.Text + "’,’" + cmb_Cinsiyet.Text + "’,’" + txt_Adres.Text + "’,’" + txt_Kilo.Text + "’,’" + txt_Boy.Text + "’,’" + txt_Göbek.Text + "’,’" + txt_Kol.Text + "’,’" + txt_Bacak.Text + "’)";

komut.ExecuteNonQuery();

baglanti.Close();

MessageBox.Show("Yeni Kişi Eklendi", "Uyarı", MessageBoxButtons.OK, MessageBoxIcon.Information);

frm1.yenile();

txt_Ad.Clear();

txt_Soyad.Clear();

txt_Tel.Clear();

txt_Adres.Clear();

txt_Kilo.Clear();

txt_Boy.Clear();

txt_Göbek.Clear();

txt_Kol.Clear();

txt_Bacak.Clear();

cmb_Cinsiyet.Text = "Seçiniz";

}

}

}

}

[/code]

Kişi Güncelle

[code lang=”csharp”]

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Data.OleDb;

namespace Spor_Salonu_Takip

{

public partial class frmGuncelle : Form

{

public Form1 frm1;

public frmGuncelle()

{

InitializeComponent();

}

OleDbConnection baglanti = new OleDbConnection("Provider=Microsoft.ace.OleDb.12.0;Data source=data.accdb");

private void btn_Guncelle_Click(object sender, EventArgs e)

{

if (txt_Ad.Text.TrimEnd() == "" || txt_Soyad.Text.TrimEnd() == "" || txt_Tel.Text.TrimEnd() == "" || txt_Adres.Text.TrimEnd() == "") MessageBox.Show("Lütfen Boş Yerleri Doldurunuz", "Uyarı", MessageBoxButtons.OK, MessageBoxIcon.Stop);

else

{

DialogResult guncellesinmi = MessageBox.Show("Kayıt Güncellensinmi ?", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);

if (guncellesinmi == DialogResult.Yes)

{

OleDbCommand kmtGuncel = new OleDbCommand();

baglanti.Open();

kmtGuncel.Connection = baglanti;

kmtGuncel.CommandText = "update Kisiler set Kisi_ad=@kisiad,Kisi_soyad=@kisisoyad, Kisi_telno=@kisitelno,Kisi_cinsiyet=@kisicinsiyet,Kisi_adres=@kisiadres where Kisi_no=@anahtar";

kmtGuncel.Parameters.AddWithValue("@kisiad", txt_Ad.Text);

kmtGuncel.Parameters.AddWithValue("@kisisoyad", txt_Soyad.Text);

kmtGuncel.Parameters.AddWithValue("@kisitelno", txt_Tel.Text);

kmtGuncel.Parameters.AddWithValue("@kisicinsiyet", cmb_Cinsiyet.Text);

kmtGuncel.Parameters.AddWithValue("@kisiadres", txt_Adres.Text);

kmtGuncel.Parameters.AddWithValue("@anahtar", frm1.dataGridView1.CurrentRow.Cells[0].Value.ToString());

kmtGuncel.ExecuteNonQuery();

baglanti.Close();

frm1.yenile();

}

}

}

}

}

[/code]

www.facebook.com/ferhatszer Sorularınız için http://www.youtube.com/channel/UCHg1d6Kl9SGx5arpqkjNEZg YOUTUBE KANALIM

PROJEYİ İNDİR