Veteriner 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.Windows.Forms;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form2 frm2;
public Form3 frm3;
public Form4 frm4;
public Form5 frm5;
public Form1()
{
InitializeComponent();
frm2 = new Form2();
frm3 = new Form3();
frm4 = new Form4();
frm5 = new Form5();
frm2.frm1 = this;
frm3.frm1 = this;
frm4.frm1 = this;
frm5.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 sahiplistele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From sahipbil", bag);
adtr.Fill(dtst, "sahipbil");
dataGridView1.DataSource = dtst.Tables["sahipbil"];
adtr.Dispose();
bag.Close();
}
public void sahiplistele2()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From sahipbil", bag);
adtr.Fill(dtst, "sahipbil");
frm4.dataGridView1.DataSource = dtst.Tables["sahipbil"];
adtr.Dispose();
bag.Close();
}
public void hastalistele()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From hastabil ", bag);
adtr.Fill(dtst, "hastabil");
dataGridView2.DataSource = dtst.Tables["hastabil"];
adtr.Dispose();
bag.Close();
}
public void hastalistele2()
{
bag.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From hastabil ", bag);
adtr.Fill(dtst, "hastabil");
frm5.dataGridView1.DataSource = dtst.Tables["hastabil"];
adtr.Dispose();
bag.Close();
}
public void sahipcombo()
{
int durum;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select Ad_Soyad from sahipbil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
durum = frm2.comboBox1.FindString(oku[0].ToString());
if (durum == -1) frm2.comboBox1.Items.Add(oku[0].ToString());
}
bag.Close();
oku.Dispose();
}
public void hastacombo()
{
int durum;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select Kabul_Doktor,Türü,İrki from hastabil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
durum = frm3.comboBox1.FindString(oku[0].ToString());
if (durum == -1) frm3.comboBox1.Items.Add(oku[0].ToString());
durum = frm3.comboBox2.FindString(oku[1].ToString());
if (durum == -1) frm3.comboBox2.Items.Add(oku[1].ToString());
durum = frm3.comboBox3.FindString(oku[2].ToString());
if (durum == -1) frm3.comboBox3.Items.Add(oku[2].ToString());
}
bag.Close();
oku.Dispose();
}
public void dosyakontrol()
{
durum = false;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select Dosya_No from sahipbil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
if (frm2.textBox1.Text == oku[0].ToString()) durum = true;
}
bag.Close();
oku.Dispose();
}
public void doktorkontrol()
{
durum = false;
bag.Open();
kmt.Connection = bag;
kmt.CommandText = "Select Adi from hastabil";
OleDbDataReader oku;
oku = kmt.ExecuteReader();
while (oku.Read())
{
if (frm3.textBox1.Text == oku[0].ToString()) durum = true;
}
bag.Close();
oku.Dispose();
}
private void Form1_Load(object sender, EventArgs e)
{
hastalistele();
sahiplistele();
dataGridView1.Columns[0].HeaderText = "Dosya No";
dataGridView1.Columns[1].HeaderText = "Kayıt Tarihi";
dataGridView1.Columns[2].HeaderText = "Ad Soyad";
dataGridView1.Columns[3].HeaderText = "Ev Telefonu";
dataGridView1.Columns[4].HeaderText = "Cev Telefonu";
dataGridView1.Columns[5].HeaderText = "İş Telefonu";
dataGridView1.Columns[6].HeaderText = "Adres";
dataGridView1.Columns[7].HeaderText = "E-Mail";
dataGridView2.Columns[0].HeaderText = "Kabul Doktoru";
dataGridView2.Columns[1].HeaderText = "Adı";
dataGridView2.Columns[2].HeaderText = "Doğum Tarihi";
dataGridView2.Columns[3].HeaderText = "Türü";
dataGridView2.Columns[4].HeaderText = "Irkı";
dataGridView2.Columns[5].HeaderText = "Cinsiyeti";
dataGridView2.Columns[6].HeaderText = "Rengi";
dataGridView2.Columns[7].HeaderText = "Ağırlığı";
dataGridView2.Columns[8].HeaderText = "Allerjisi";
dataGridView2.Columns[9].HeaderText = "Aşı İsmi";
dataGridView2.Columns[10].HeaderText = "Etki Süresi";
dataGridView2.Columns[11].HeaderText = "Stok Sayısı";
dataGridView2.Columns[12].HeaderText = "Notlar";
}
private void button5_Click(object sender, EventArgs e)
{
Application.Exit();
}
private void button1_Click(object sender, EventArgs e)
{
frm2.ShowDialog();
}
private void button2_Click(object sender, EventArgs e)
{
frm3.ShowDialog();
}
private void button3_Click(object sender, EventArgs e)
{
frm4.ShowDialog();
}
private void button4_Click(object sender, EventArgs e)
{
frm5.ShowDialog();
}
private void textBox1_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From sahipbil", bag);
if (textBox1.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from sahipbil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "sahipbil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From sahipbil" +
" where(Dosya_No like ‘%" + textBox1.Text + "%’ )";
dtst.Tables["sahipbil"].Clear();
adtr.Fill(dtst, "sahipbil");
bag.Close();
}
private void textBox2_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From sahipbil", bag);
if (textBox2.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from sahipbil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "sahipbil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From sahipbil" +
" where(Ad_Soyad like ‘%" + textBox2.Text + "%’ )";
dtst.Tables["sahipbil"].Clear();
adtr.Fill(dtst, "sahipbil");
bag.Close();
}
private void textBox3_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From hastabil", bag);
if (textBox3.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from hastabil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "hastabil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From hastabil" +
" where(Türü like ‘%" + textBox3.Text + "%’ )";
dtst.Tables["hastabil"].Clear();
adtr.Fill(dtst, "hastabil");
bag.Close();
}
private void textBox4_TextChanged(object sender, EventArgs e)
{
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From hastabil", bag);
if (textBox4.Text == "")
{
kmt.Connection = bag;
kmt.CommandText = "Select * from hastabil";
adtr.SelectCommand = kmt;
adtr.Fill(dtst, "hastabil");
}
if (Convert.ToBoolean(bag.State) == false)
{
bag.Open();
}
adtr.SelectCommand.CommandText = " Select * From hastabil" +
" where(İrki like ‘%" + textBox4.Text + "%’ )";
dtst.Tables["hastabil"].Clear();
adtr.Fill(dtst, "hastabil");
bag.Close();
}
}
}
[/code]
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.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
public partial class Form2 : Form
{
public Form1 frm1;
public Form2()
{
InitializeComponent();
}
private void Form2_Load(object sender, EventArgs e)
{
frm1.sahipcombo();
}
private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
frm1.dosyakontrol();
if (frm1.durum == false)
{
if (textBox1.Text != "")
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO sahipbil(Dosya_No,Kayit_Tarihi,Ad_Soyad,Ev_Tel,Cep_Tel,İs_Tel,Adres,E_Mail) VALUES (‘" + textBox1.Text + "’,’" + dateTimePicker1.Text + "’,’" + comboBox1.Text + "’,’" + textBox5.Text + "’,’" + textBox6.Text + "’,’" + textBox7.Text + "’,’" + textBox8.Text + "’,’" + textBox9.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
for (int i = 0; i < this.Controls.Count; i++)
{
if (this.Controls[i] is TextBox) this.Controls[i].Text = "";
if (this.Controls[i] is ComboBox) this.Controls[i].Text = "";
}
frm1.dtst.Tables["sahipbil"].Clear();
frm1.sahiplistele();
frm1.sahipcombo();
MessageBox.Show("Kayıt işlemi tamamlandı !");
}
else MessageBox.Show("Boş alanları doldurunuz !");
}
}
}
}
[/code]
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.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
public partial class Form3 : Form
{
public Form1 frm1;
public Form3()
{
InitializeComponent();
}
private void Form3_Load(object sender, EventArgs e)
{
frm1.hastacombo();
}
private void button2_Click(object sender, EventArgs e)
{
this.Close();
}
private void button1_Click(object sender, EventArgs e)
{
frm1.doktorkontrol();
if (frm1.durum == false)
{
if (textBox1.Text != "")
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "INSERT INTO hastabil(Kabul_Doktor,Adi,Dogum_Tarihi,Türü,İrki,Cinsiyeti,Rengi,Agirligi,Allerisi,Asi_İsmi,Etki_Süresi,Stok_Sayisi,Notlar) VALUES (‘" + comboBox1.Text + "’,’" + textBox1.Text + "’,’" + comboBox2.Text + "’,’" + comboBox3.Text + "’,’" + textBox2.Text + "’,’" + textBox3.Text + "’,’" + textBox4.Text + "’,’" + textBox5.Text + "’,’" + textBox6.Text + "’,’" + textBox7.Text + "’,’" + textBox8.Text + "’,’" + textBox9.Text + "’,’" + textBox10.Text + "’) ";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
textBox7.Text = "";
textBox8.Text = "";
textBox9.Text = "";
textBox10.Text = "";
for (int i = 0; i < this.Controls.Count; i++)
{
if (this.Controls[i] is TextBox) this.Controls[i].Text = "";
if (this.Controls[i] is ComboBox) this.Controls[i].Text = "";
}
frm1.dtst.Tables["hastabil"].Clear();
frm1.hastacombo();
frm1.hastalistele();
MessageBox.Show("Kayıt işlemi tamamlandı !");
}
else MessageBox.Show("Boş alanları doldurunuz !");
}
}
}
}
[/code]
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.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
public partial class Form4 : Form
{
public Form1 frm1;
public Form4()
{
InitializeComponent();
}
private void button2_Click(object sender, EventArgs e)
{
frm1.dtst.Tables["sahipbil"].Clear();
frm1.sahiplistele();
this.Close();
}
private void Form4_Load(object sender, EventArgs e)
{
frm1.dtst.Tables["sahipbil"].Clear();
frm1.sahiplistele2();
dataGridView1.Columns[0].HeaderText = "Dosya No";
dataGridView1.Columns[1].HeaderText = "Kayıt Tarihi";
dataGridView1.Columns[2].HeaderText = "Ad Soyad";
dataGridView1.Columns[3].HeaderText = "Ev Telefonu";
dataGridView1.Columns[4].HeaderText = "Cev Telefonu";
dataGridView1.Columns[5].HeaderText = "İş Telefonu";
dataGridView1.Columns[6].HeaderText = "Adres";
dataGridView1.Columns[7].HeaderText = "E-Mail";
}
private void button1_Click(object sender, EventArgs e)
{
string silinecek;
try
{
int row = 0;
for (row = 0; row <= dataGridView1.Rows.Count; row++)
{
if (dataGridView1.Rows[row].Cells[0].Selected == true || dataGridView1.Rows[row].Cells[1].Selected == true || dataGridView1.Rows[row].Cells[2].Selected == true || dataGridView1.Rows[row].Cells[3].Selected == true || dataGridView1.Rows[row].Cells[4].Selected == true || dataGridView1.Rows[row].Cells[5].Selected == true || dataGridView1.Rows[row].Cells[6].Selected == true || dataGridView1.Rows[row].Cells[7].Selected == true)
{
break;
}
}
silinecek = dataGridView1.Rows[row].Cells[0].Value.ToString();
DialogResult cevap;
cevap = MessageBox.Show("Kaydı silmek istediğinizden eminmisiniz", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "DELETE from sahipbil WHERE Dosya_No=’" + silinecek + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
frm1.dtst.Tables["sahipbil"].Clear();
frm1.sahiplistele2();
}
}
catch
{ ;}
}
}
}
[/code]
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.Text;
using System.Windows.Forms;
namespace WindowsFormsApplication1
{
public partial class Form5 : Form
{
public Form1 frm1;
public Form5()
{
InitializeComponent();
}
private void button2_Click(object sender, EventArgs e)
{
frm1.dtst.Tables["hastabil"].Clear();
frm1.hastalistele();
this.Close();
}
private void Form5_Load(object sender, EventArgs e)
{
frm1.dtst.Tables["hastabil"].Clear();
frm1.hastalistele2();
dataGridView1.Columns[0].HeaderText = "Kabul Doktoru";
dataGridView1.Columns[1].HeaderText = "Adı";
dataGridView1.Columns[2].HeaderText = "Doğum Tarihi";
dataGridView1.Columns[3].HeaderText = "Türü";
dataGridView1.Columns[4].HeaderText = "Irkı";
dataGridView1.Columns[5].HeaderText = "Cinsiyeti";
dataGridView1.Columns[6].HeaderText = "Rengi";
dataGridView1.Columns[7].HeaderText = "Ağırlığı";
dataGridView1.Columns[8].HeaderText = "Allerjisi";
dataGridView1.Columns[9].HeaderText = "Aşı İsmi";
dataGridView1.Columns[10].HeaderText = "Etki Süresi";
dataGridView1.Columns[11].HeaderText = "Stok Sayısı";
dataGridView1.Columns[12].HeaderText = "Notlar";
}
private void button1_Click(object sender, EventArgs e)
{
string silinecek;
try
{
int row = 0;
for (row = 0; row <= dataGridView1.Rows.Count; row++)
{
if (dataGridView1.Rows[row].Cells[0].Selected == true || dataGridView1.Rows[row].Cells[1].Selected == true || dataGridView1.Rows[row].Cells[2].Selected == true || dataGridView1.Rows[row].Cells[3].Selected == true || dataGridView1.Rows[row].Cells[4].Selected == true || dataGridView1.Rows[row].Cells[5].Selected == true || dataGridView1.Rows[row].Cells[6].Selected == true || dataGridView1.Rows[row].Cells[7].Selected == true || dataGridView1.Rows[row].Cells[8].Selected == true || dataGridView1.Rows[row].Cells[9].Selected == true || dataGridView1.Rows[row].Cells[10].Selected == true || dataGridView1.Rows[row].Cells[11].Selected == true || dataGridView1.Rows[row].Cells[12].Selected == true)
{
break;
}
}
silinecek = dataGridView1.Rows[row].Cells[0].Value.ToString();
DialogResult cevap;
cevap = MessageBox.Show("Kaydı silmek istediğinizden eminmisiniz", "Uyarı", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (cevap == DialogResult.Yes)
{
frm1.bag.Open();
frm1.kmt.Connection = frm1.bag;
frm1.kmt.CommandText = "DELETE from hastabil WHERE Kabul_Doktor=’" + silinecek + "’";
frm1.kmt.ExecuteNonQuery();
frm1.kmt.Dispose();
frm1.bag.Close();
frm1.dtst.Tables["hastabil"].Clear();
frm1.hastalistele2();
}
}
catch
{ ;}
}
}
}
[/code]
Bu ve benzeri takip programlar veya bu programa artı özellikler ekletmek istiyorsanız gorselprogram@gmail.com adresine mail atın.
bişey rica etsem dişçi takip programı c# ile yardım edebilirmisinz ?
Örnek Veteriner Veritabanı varmı
Veritabanları projelerin bin–debug klasöründe