Spor Kompleksi Takip Programı C#

Spor Kompleksi 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.Drawing;
using System.Linq;
using System.Data.OleDb;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication13
{
public partial class Form1 : Form
{
public Form2 frm2;
public Form3 frm3;
public Form4 frm4;
public Form5 frm5;
public Form6 frm6;

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 listele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("Select * From Tablo1", bag);
adtr.Fill(dtst, "Tablo1");
frm3.dataGridView1.DataSource = dtst;
frm3.dataGridView1.DataMember = "Tablo1";
bag.Close();
adtr.Dispose();
}
public Form1()
{
InitializeComponent();
frm2 = new Form2();
frm3 = new Form3();
frm4 = new Form4();
frm5 = new Form5();
frm6 = new Form6();

frm2.frm1 = this;
frm3.frm1 = this;
frm4.frm1 = this;
frm5.frm1 = this;
frm6.frm1 = this;
}

private void button1_Click(object sender, EventArgs e)
{
this.Hide();
frm2.Show();
}

private void Form1_Load(object sender, EventArgs e)
{
listele();
}

private void button6_Click(object sender, EventArgs e)
{
this.Hide();
frm3.Show();
}

private void button2_Click(object sender, EventArgs e)
{
this.Hide();
frm4.Show();
}

private void button3_Click(object sender, EventArgs e)
{
this.Hide();
frm5.Show();
}

private void button4_Click(object sender, EventArgs e)
{
this.Hide();
frm6.Show();
}

private void button5_Click(object sender, EventArgs e)
{
Close();
}
}
}

[/code]

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

FORM2 İç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 Form2 : Form
{
public Form1 frm1;
public Form2()
{
InitializeComponent();
}

private void Form2_Load(object sender, EventArgs e)
{

}

private void button4_Click(object sender, EventArgs e)
{
this.Hide();
frm1.Show();
}

private void button6_Click(object sender, EventArgs e)
{
this.Hide();
frm1.frm3.Show();
}

private void button7_Click(object sender, EventArgs e)
{
this.Hide();
frm1.frm6.Show();
}

private void button5_Click(object sender, EventArgs e)
{
Close();
}

private void button1_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO Tablo1(tc,ad,soyad,tel,meslek,d_tarih,boy,kilo) VALUES (‘" + textBox1.Text + "’,’" + textBox2.Text + "’,’" + textBox3.Text + "’,’" + textBox4.Text + "’,’" + textBox5.Text + "’,’" + textBox6.Text + "’,’" + textBox7.Text + "’ ,’" + textBox8.Text + "’) ";

frm1.kmt.ExecuteNonQuery();
frm1.bag.Close();
frm1.kmt.Dispose();
frm1.dtst.Clear();
frm1.listele();

textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
}

private void button2_Click(object sender, EventArgs e)
{
if (textBox1.Text == "")
{
MessageBox.Show("Lütfen silinicek kaydın tcsini giriniz");
}
else
{
try
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "DELETE FROM Tablo1 WHERE tc=’" + textBox1.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.bag.Close();
frm1.kmt.Dispose();
frm1.dtst.Clear();
frm1.listele();
MessageBox.Show("Kayıt Silindi");
textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";

}
catch
{

}
}
}

private void button3_Click(object sender, EventArgs e)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "UPDATE Tablo1 SET ad=’" + textBox2.Text + "’,soyad=’" + textBox3.Text + "’,tel=’" + textBox4.Text + "’ ,meslek=’" + textBox5.Text + "’ ,d_tarih=’" + textBox6.Text + "’,boy=’" + textBox7.Text + "’,kilo=’" + textBox8.Text + "’ WHERE tc=’" + textBox1.Text + "’";
frm1.kmt.ExecuteNonQuery();
frm1.bag.Close();
frm1.kmt.Dispose();
frm1.dtst.Clear();
frm1.listele();

textBox1.Text = "";
textBox2.Text = "";
textBox3.Text = "";
textBox4.Text = "";
textBox5.Text = "";
textBox6.Text = "";
textBox7.Text = "";
textBox8.Text = "";
}
}
}

[/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.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace WindowsFormsApplication13
{
public partial class Form3 : Form
{
public Form1 frm1;
public Form3()
{
InitializeComponent();
}

private void button4_Click(object sender, EventArgs e)
{
this.Hide();
frm1.Show();
}

private void button6_Click(object sender, EventArgs e)
{
this.Hide();
frm1.frm2.Show();
}

private void button7_Click(object sender, EventArgs e)
{
this.Hide();
frm1.frm6.Show();
}

private void button1_Click(object sender, EventArgs e)
{
Close();
}
}
}

[/code]

FORM4 İçerisine Yazılacak Kodlar…

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

private void button4_Click(object sender, EventArgs e)
{
this.Hide();
frm1.Show();
}

private void button6_Click(object sender, EventArgs e)
{
this.Hide();
frm1.frm2.Show();
}

private void button7_Click(object sender, EventArgs e)
{
this.Hide();
frm1.frm6.Show();
}

private void button1_Click(object sender, EventArgs e)
{
Close();
}
}
[/code]

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

FORM5 İçerisine Yazılacak Kodlar…

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

private void button4_Click(object sender, EventArgs e)
{
this.Hide();
frm1.Show();
}

private void button6_Click(object sender, EventArgs e)
{
this.Hide();
frm1.frm2.Show();
}

private void button7_Click(object sender, EventArgs e)
{
this.Hide();
frm1.frm6.Show();
}

private void button1_Click(object sender, EventArgs e)
{
Close();
}
}
[/code]

FORM6 İçerisine Yazılacak Kodlar…

[code language=”CSharp”]
public partial class Form6 : Form
{
public Form1 frm1;
public Form6()
{
InitializeComponent();
}
private void button6_Click(object sender, EventArgs e)
{
this.Hide();
frm1.frm2.Show();
}

private void button4_Click(object sender, EventArgs e)
{
this.Hide();
frm1.Show();
}

private void button7_Click(object sender, EventArgs e)
{
this.Hide();
frm1.frm3.Show();
}

private void button1_Click(object sender, EventArgs e)
{
Close();
}
}
[/code]

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

Projeyi İNDİR