Kütüphane Takip Programı (Kapsamlı) – 2 – C#

Kütüphane Takip Programı (Kapsamlı) C#

FORM1 İçerisine Yazılacak Kodlar…

FORM2 İçerisine Yazılacak Kodlar…

[code language=”CSharp”] 
public partial class Form2 : Form 
{ 
public Form3 frm3; 
public Form1 frm1;
public Form2() 
{ 
InitializeComponent(); 
frm3 = new Form3();
}
private void Form2_Load(object sender, EventArgs e) 
{ 
timer1.Start(); 
label1.Text = "Kütüphane Programına Hoşgeldiniz "; 
}
private void timer1_Tick(object sender, EventArgs e) 
{ 
label1.Text = label1.Text.Substring(1) + label1.Text[0].ToString(); 
}
private void button1_Click(object sender, EventArgs e) 
{ 
SoundPlayer player = new SoundPlayer(); 
string path = "C:\\windows\\media\\ding.wav"; 
player.SoundLocation = path; 
player.Play(); 
Close(); 
this.Visible = false; 
frm3.ShowDialog();
} 
} 
[/code]

FORM3 İçerisine Yazılacak Kodlar…

FORM4 İç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 Ayca_Kahraman 
{ 
public partial class Form4 : Form 
{ 
public Form6 frm6; 
public Form5 frm5; 
public Form3 frm3; 
public Form4() 
{ 
InitializeComponent();
frm5 = new Form5(); 
frm6 = new Form6();
frm5.frm4 = this; 
frm6.frm4 = 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 int row = 0;
public void göster() 
{ 
bag.Open(); 
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From üyebil", bag); 
adtr.Fill(dtst, "üyebil"); 
dataGridView1.DataSource = dtst.Tables["üyebil"]; 
adtr.Dispose(); 
bag.Close(); 
}
public void combo() 
{ 
int durum; 
bag.Open(); 
kmt.Connection = bag; 
kmt.CommandText = "Select Sinifi from üyebil"; 
OleDbDataReader oku; 
oku = kmt.ExecuteReader(); 
while (oku.Read()) 
{ 
durum = frm5.comboBox1.FindString(oku[0].ToString()); 
if (durum == -1) frm5.comboBox1.Items.Add(oku[0].ToString()); 
} 
bag.Close(); 
oku.Dispose(); 
}
private void Form4_Load(object sender, EventArgs e) 
{ 
göster(); 
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; 
dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically; 
dataGridView1.Columns[0].HeaderText = "Üye Adı"; 
dataGridView1.Columns[1].HeaderText = "Üye Soyadı"; 
dataGridView1.Columns[2].HeaderText = "Kişi/Öğrenci No"; 
dataGridView1.Columns[3].HeaderText = "Sınıfı"; 
dataGridView1.Columns[4].HeaderText = "TC Kimlik No"; 
dataGridView1.Columns[5].HeaderText = "Telefon"; 
dataGridView1.Columns[6].HeaderText = "E-Posta"; 
dataGridView1.Columns[7].HeaderText = "Adres"; 
dataGridView1.Columns[8].HeaderText = "Şehir"; 
}
private void button1_Click(object sender, EventArgs e) 
{ 
frm5.ShowDialog(); 
}
private void button5_Click(object sender, EventArgs e) 
{ 
dtst.Tables["üyebil"].Clear(); 
this.Close(); 
}
private void button2_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) 
{ 
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) 
{ 
bag.Open(); 
kmt.Connection = bag; 
kmt.CommandText = "DELETE from üyebil WHERE Üye_Adi=’" + silinecek + "’"; 
kmt.ExecuteNonQuery(); 
kmt.Dispose(); 
bag.Close(); 
dtst.Tables["üyebil"].Clear(); 
göster(); 
} 
} 
catch 
{ ;} 
}
private void button3_Click(object sender, EventArgs e) 
{
frm6.ShowDialog(); 
}
private void textBox1_TextChanged(object sender, EventArgs e) 
{ 
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From üyebil", bag); 
if (textBox1.Text == "") 
{ 
kmt.Connection = bag; 
kmt.CommandText = "Select * from üyebil"; 
adtr.SelectCommand = kmt; 
adtr.Fill(dtst, "üyebil"); 
} 
if (Convert.ToBoolean(bag.State) == false) 
{ 
bag.Open(); 
} 
adtr.SelectCommand.CommandText = " Select * From üyebil" + 
" where(Üye_Adi like ‘%" + textBox1.Text + "%’ )"; 
dtst.Tables["üyebil"].Clear(); 
adtr.Fill(dtst, "üyebil"); 
bag.Close(); 
}
private void textBox2_TextChanged(object sender, EventArgs e) 
{ 
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From üyebil", bag); 
if (textBox2.Text == "") 
{ 
kmt.Connection = bag; 
kmt.CommandText = "Select * from üyebil"; 
adtr.SelectCommand = kmt; 
adtr.Fill(dtst, "üyebil"); 
} 
if (Convert.ToBoolean(bag.State) == false) 
{ 
bag.Open(); 
} 
adtr.SelectCommand.CommandText = " Select * From üyebil" + 
" where(Tc_Kimlik like ‘%" + textBox2.Text + "%’ )"; 
dtst.Tables["üyebil"].Clear(); 
adtr.Fill(dtst, "üyebil"); 
bag.Close(); 
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) 
{ 
frm6.textBox1.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString(); 
frm6.textBox2.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString(); 
frm6.textBox3.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString(); 
frm6.textBox4.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString(); 
frm6.textBox5.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString(); 
frm6.textBox6.Text = dataGridView1.CurrentRow.Cells[6].Value.ToString(); 
frm6.textBox7.Text = dataGridView1.CurrentRow.Cells[7].Value.ToString(); 
frm6.textBox8.Text = dataGridView1.CurrentRow.Cells[8].Value.ToString(); 
} 
} 
}
[/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 Ayca_Kahraman 
{ 
public partial class Form5 : Form 
{
public Form3 frm3; 
public Form4 frm4; 
public Form5() 
{ 
InitializeComponent(); 
}
private void Form5_Load(object sender, EventArgs e) 
{ 
frm4.combo(); 
}
private void button2_Click(object sender, EventArgs e) 
{ 
this.Close(); 
}
private void button1_Click(object sender, EventArgs e) 
{ 
if (textBox4.Text != "" ) 
{ 
frm4.bag.Open(); 
frm4.kmt.Connection = frm4.bag; 
frm4.kmt.CommandText = "INSERT INTO üyebil(Üye_Adi,Üy_Soydi,Nosu,Sinifi,Tc_Kimlik,Telefonu,E_Posta,Adresi,Sehir) VALUES (‘" + textBox1.Text + "’,’" + textBox2.Text + "’,’" + textBox3.Text + "’,’" + comboBox1.Text + "’,’" + textBox4.Text + "’,’" + textBox5.Text + "’,’" + textBox6.Text + "’,’" + textBox7.Text + "’,’" + textBox8.Text + "’) "; 
frm4.kmt.ExecuteNonQuery(); 
frm4.kmt.Dispose(); 
frm4.bag.Close(); 
textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox4.Clear(); 
textBox5.Clear(); textBox6.Clear(); textBox7.Clear(); textBox8.Clear();
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 = ""; 
} 
frm4.dtst.Tables["üyebil"].Clear(); 
frm4.göster(); 
frm4.combo(); 
MessageBox.Show("Kayıt işlemi tamamlandı !");
}
} 
} 
}
[/code]

FORM6 İçerisine Yazılacak Kodlar…

[code language=”CSharp”] 
public partial class Form6 : Form 
{ 
public Form3 frm3; 
public Form4 frm4; 
public Form5 frm5; 
public Form6() 
{ 
InitializeComponent(); 
}
private void button2_Click(object sender, EventArgs e) 
{ 
this.Close(); 
}
private void button1_Click(object sender, EventArgs e) 
{ 
try 
{ 
frm4.bag.Open(); 
frm4.kmt.Connection = frm4.bag; 
frm4.kmt.CommandText = "UPDATE üyebil SET Üye_Adi=’" + textBox1.Text + "’,Üy_Soydi=’" + textBox2.Text + "’,Nosu=’" + textBox3.Text + "’,Sinifi=’" + comboBox1.Text + "’,Tc_Kimlik=’" + textBox4.Text + "’,Telefonu=’" + textBox5.Text + "’,E_Posta=’" + textBox6.Text + "’,Adresi=’" + textBox7.Text + "’,Sehir=’" + textBox8.Text + "’ WHERE Üye_Adi=’" + frm4.dataGridView1.CurrentRow.Cells[0].Value.ToString() + "’"; 
frm4.kmt.ExecuteNonQuery(); 
frm4.kmt.Dispose(); 
frm4.bag.Close(); 
frm4.dtst.Tables["üyebil"].Clear(); 
frm4.göster(); 
this.Close(); 
} 
catch 
{ 
; 
} 
} 
} 
[/code]

FORM7 İç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 Ayca_Kahraman 
{ 
public partial class Form7 : Form 
{ 
public Form3 frm3; 
public Form4 frm4; 
public Form5 frm5; 
public Form6 frm6; 
public Form8 frm8; 
public Form9 frm9; 
public Form10 frm10; 
public Form11 frm11; 
public Form12 frm12; 
public Form7() 
{ 
InitializeComponent();
frm8 = new Form8(); 
frm9 = new Form9();
frm8.frm7 = this; 
frm9.frm7 = 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 int row = 0;
public void göster1() 
{ 
bag.Open(); 
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kitapbil", bag); 
adtr.Fill(dtst, "kitapbil"); 
dataGridView1.DataSource = dtst.Tables["kitapbil"]; 
adtr.Dispose(); 
bag.Close(); 
}
public void combo1() 
{ 
int durum; 
bag.Open(); 
kmt.Connection = bag; 
kmt.CommandText = "Select Dolap_Ab,Kategorisi from kitapbil"; 
OleDbDataReader oku; 
oku = kmt.ExecuteReader(); 
while (oku.Read()) 
{ 
durum = frm8.comboBox1.FindString(oku[0].ToString()); 
if (durum == -1) frm8.comboBox1.Items.Add(oku[0].ToString()); 
durum = frm8.comboBox2.FindString(oku[1].ToString()); 
if (durum == -1) frm8.comboBox2.Items.Add(oku[1].ToString()); 
} 
bag.Close(); 
oku.Dispose(); 
}
private void Form7_Load(object sender, EventArgs e) 
{ 
göster1(); 
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; 
dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically; 
dataGridView1.Columns[0].HeaderText = "Barkod No"; 
dataGridView1.Columns[1].HeaderText = "Kitap Adı"; 
dataGridView1.Columns[2].HeaderText = "Demirbaş No"; 
dataGridView1.Columns[3].HeaderText = "Dolap Adı"; 
dataGridView1.Columns[4].HeaderText = "Yayın Evi"; 
dataGridView1.Columns[5].HeaderText = "Yazar1"; 
dataGridView1.Columns[6].HeaderText = "Yazar2"; 
dataGridView1.Columns[7].HeaderText = "Yazar3"; 
dataGridView1.Columns[8].HeaderText = "Stok Sayısı"; 
dataGridView1.Columns[9].HeaderText = "Kategorisi"; 
dataGridView1.Columns[10].HeaderText = "Basım Tarihi"; 
dataGridView1.Columns[11].HeaderText = "Sayfa Sayısı"; 
dataGridView1.Columns[12].HeaderText = "Cilt No"; 
dataGridView1.Columns[13].HeaderText = "Baskısı"; 
dataGridView1.Columns[14].HeaderText = "ISBN Numarası"; 
dataGridView1.Columns[15].HeaderText = "Fiyatı"; 
dataGridView1.Columns[16].HeaderText = "Anahtar Sözcük";
}
private void button5_Click(object sender, EventArgs e) 
{ 
dtst.Tables["kitapbil"].Clear(); 
this.Close(); 
}
private void button1_Click(object sender, EventArgs e) 
{ 
frm8.ShowDialog(); 
}
private void button3_Click(object sender, EventArgs e) 
{
frm9.ShowDialog(); 
}
private void button2_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 || dataGridView1.Rows[row].Cells[13].Selected == true || dataGridView1.Rows[row].Cells[14].Selected == true || dataGridView1.Rows[row].Cells[15].Selected == true || dataGridView1.Rows[row].Cells[16].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) 
{ 
bag.Open(); 
kmt.Connection = bag; 
kmt.CommandText = "DELETE from kitapbil WHERE Barkod_No =’" + silinecek + "’"; 
kmt.ExecuteNonQuery(); 
kmt.Dispose(); 
bag.Close(); 
dtst.Tables["kitapbil"].Clear(); 
göster1(); 
} 
} 
catch 
{ ;} 
}
private void textBox1_TextChanged(object sender, EventArgs e) 
{ 
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kitapbil", bag); 
if (textBox1.Text == "") 
{ 
kmt.Connection = bag; 
kmt.CommandText = "Select * from kitapbil"; 
adtr.SelectCommand = kmt; 
adtr.Fill(dtst, "kitapbil"); 
} 
if (Convert.ToBoolean(bag.State) == false) 
{ 
bag.Open(); 
} 
adtr.SelectCommand.CommandText = " Select * From kitapbil" + 
" where(Barkod_No like ‘%" + textBox1.Text + "%’ )"; 
dtst.Tables["kitapbil"].Clear(); 
adtr.Fill(dtst, "kitapbil"); 
bag.Close(); 
}
private void textBox2_TextChanged(object sender, EventArgs e) 
{ 
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From kitapbil", bag); 
if (textBox2.Text == "") 
{ 
kmt.Connection = bag; 
kmt.CommandText = "Select * from kitapbil"; 
adtr.SelectCommand = kmt; 
adtr.Fill(dtst, "kitapbil"); 
} 
if (Convert.ToBoolean(bag.State) == false) 
{ 
bag.Open(); 
} 
adtr.SelectCommand.CommandText = " Select * From kitapbil" + 
" where(Kitap_Adi like ‘%" + textBox2.Text + "%’ )"; 
dtst.Tables["kitapbil"].Clear(); 
adtr.Fill(dtst, "kitapbil"); 
bag.Close(); 
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) 
{ 
frm9.textBox1.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString(); 
frm9.textBox2.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString(); 
frm9.textBox3.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString(); 
frm9.textBox4.Text = dataGridView1.CurrentRow.Cells[4].Value.ToString(); 
frm9.textBox5.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString(); 
frm9.textBox6.Text = dataGridView1.CurrentRow.Cells[6].Value.ToString(); 
frm9.textBox7.Text = dataGridView1.CurrentRow.Cells[7].Value.ToString(); 
frm9.textBox8.Text = dataGridView1.CurrentRow.Cells[8].Value.ToString(); 
frm9.textBox9.Text = dataGridView1.CurrentRow.Cells[10].Value.ToString(); 
frm9.textBox10.Text = dataGridView1.CurrentRow.Cells[11].Value.ToString(); 
frm9.textBox11.Text = dataGridView1.CurrentRow.Cells[12].Value.ToString(); 
frm9.textBox12.Text = dataGridView1.CurrentRow.Cells[13].Value.ToString(); 
frm9.textBox13.Text = dataGridView1.CurrentRow.Cells[14].Value.ToString(); 
frm9.textBox14.Text = dataGridView1.CurrentRow.Cells[15].Value.ToString(); 
frm9.textBox15.Text = dataGridView1.CurrentRow.Cells[16].Value.ToString(); 
} 
} 
}
[/code]

FORM8 İç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 Ayca_Kahraman 
{ 
public partial class Form8 : Form 
{ 
public Form3 frm3; 
public Form4 frm4; 
public Form5 frm5; 
public Form6 frm6; 
public Form7 frm7; 
public Form9 frm9; 
public Form10 frm10; 
public Form11 frm11; 
public Form12 frm12; 
public Form8() 
{ 
InitializeComponent();
}
private void Form8_Load(object sender, EventArgs e) 
{ 
frm7.combo1(); 
}
private void button2_Click(object sender, EventArgs e) 
{ 
label19.Text = ""; 
this.Close(); 
}
private void button1_Click(object sender, EventArgs e) 
{ 
label19.Text = textBox2.Text; 
if (textBox2.Text != "") 
{ 
frm7.bag.Open(); 
frm7.kmt.Connection = frm7.bag; 
frm7.kmt.CommandText = "INSERT INTO kitapbil(Barkod_No,Kitap_Adi,Demirbas,Dolap_Ab,Yayinevi,Yazara,Yazarb,Yazarc,Stok_Sayisi,Kategorisi,Basim_Tarihi,Sayfa_Say,Cilt,Baskisi,Sbn_Num,Fiyati,Anahtar_Söz) VALUES (‘" + textBox1.Text + "’,’" + textBox2.Text + "’,’" + textBox3.Text + "’,’" + comboBox1.Text + "’,’" + textBox4.Text + "’,’" + textBox5.Text + "’,’" + textBox6.Text + "’,’" + textBox7.Text + "’,’" + textBox8.Text + "’,’" + comboBox2.Text + "’,’" + textBox9.Text + "’,’" + textBox10.Text + "’,’" + textBox11.Text + "’,’" + textBox12.Text + "’,’" + textBox13.Text + "’,’" + textBox14.Text + "’,’" + textBox15.Text + "’) "; 
frm7.kmt.ExecuteNonQuery(); 
frm7.kmt.Dispose(); 
frm7.bag.Close(); 
textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox4.Clear(); textBox5.Clear(); 
textBox6.Clear(); textBox7.Clear(); textBox8.Clear(); textBox9.Clear(); textBox10.Clear(); 
textBox11.Clear(); textBox12.Clear(); textBox13.Clear(); textBox14.Clear(); textBox15.Clear();
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 = ""; 
} 
frm7.dtst.Tables["kitapbil"].Clear(); 
frm7.göster1(); 
frm7.combo1(); 
MessageBox.Show("Kayıt işlemi tamamlandı !");
} 
} 
} 
}
[/code]

FORM9 İçerisine Yazılacak Kodlar…

[code language=”CSharp”] 
public partial class Form9 : Form 
{ 
public Form3 frm3; 
public Form4 frm4; 
public Form5 frm5; 
public Form6 frm6; 
public Form8 frm8; 
public Form7 frm7; 
public Form10 frm10; 
public Form11 frm11; 
public Form12 frm12; 
public Form9() 
{ 
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e) 
{ 
try 
{ 
frm7.bag.Open(); 
frm7.kmt.Connection = frm7.bag; 
frm7.kmt.CommandText = "UPDATE kitapbil SET Barkod_No=’" + textBox1.Text + "’,Kitap_Adi=’" + textBox2.Text + "’,Demirbas=’" + textBox3.Text + "’,Yayinevi=’" + textBox4.Text + "’,Yazara=’" + textBox5.Text + "’,Yazarb=’" + textBox6.Text + "’,Yazarc=’" + textBox7.Text + "’,Stok_Sayisi=’" + textBox8.Text + "’,Basim_Tarihi=’" + textBox9.Text + "’,Sayfa_Say=’" + textBox10.Text + "’,Cilt=’" + textBox11.Text + "’,Baskisi=’" + textBox12.Text + "’,Sbn_Num=’" + textBox13.Text + "’,Fiyati=’" + textBox14.Text + "’,Anahtar_Söz=’" + textBox15.Text + "’ WHERE Barkod_No=’" + frm7.dataGridView1.CurrentRow.Cells[0].Value.ToString() + "’"; 
frm7.kmt.ExecuteNonQuery(); 
frm7.kmt.Dispose(); 
frm7.bag.Close(); 
frm7.dtst.Tables["kitapbil"].Clear(); 
frm7.göster1(); 
this.Close(); 
} 
catch 
{ 
; 
} 
}
private void button2_Click(object sender, EventArgs e) 
{ 
this.Close(); 
} 
} 
[/code]

FORM10 İç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 Ayca_Kahraman 
{ 
public partial class Form10 : Form 
{ 
public Form3 frm3; 
public Form4 frm4; 
public Form5 frm5; 
public Form6 frm6; 
public Form8 frm8; 
public Form9 frm9; 
public Form7 frm7; 
public Form11 frm11; 
public Form12 frm12; 
public Form10() 
{ 
InitializeComponent();
frm11 = new Form11(); 
frm12 = new Form12();
frm11.frm10 = this; 
frm12.frm10 = 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 int row = 0;
public void göster2() 
{ 
bag.Open(); 
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From okuyucubil", bag); 
adtr.Fill(dtst, "okuyucubil"); 
dataGridView1.DataSource = dtst.Tables["okuyucubil"]; 
adtr.Dispose(); 
bag.Close(); 
}
public void combo2() 
{ 
int durum; 
bag.Open(); 
kmt.Connection = bag; 
kmt.CommandText = "Select Snf,Dogm_Yeri from okuyucubil"; 
OleDbDataReader oku; 
oku = kmt.ExecuteReader(); 
while (oku.Read()) 
{ 
durum = frm11.comboBox1.FindString(oku[0].ToString()); 
if (durum == -1) frm11.comboBox1.Items.Add(oku[0].ToString()); 
durum = frm11.comboBox2.FindString(oku[1].ToString()); 
if (durum == -1) frm11.comboBox2.Items.Add(oku[1].ToString()); 
} 
bag.Close(); 
oku.Dispose(); 
}
private void Form10_Load(object sender, EventArgs e) 
{ 
göster2(); 
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect; 
dataGridView1.EditMode = DataGridViewEditMode.EditProgrammatically; 
dataGridView1.Columns[0].HeaderText = "TC Kimlik No"; 
dataGridView1.Columns[1].HeaderText = "Adı Soyadı"; 
dataGridView1.Columns[2].HeaderText = "Sınıfı"; 
dataGridView1.Columns[3].HeaderText = "Okul No"; 
dataGridView1.Columns[4].HeaderText = "Doğum Yeri"; 
dataGridView1.Columns[5].HeaderText = "Doğum Tarihi"; 
dataGridView1.Columns[6].HeaderText = "Cinsiyet"; 
dataGridView1.Columns[7].HeaderText = "Adres"; 
dataGridView1.Columns[8].HeaderText = "Ev Telefonu"; 
dataGridView1.Columns[9].HeaderText = "Cep Telefonu"; 
dataGridView1.Columns[10].HeaderText = "E-Mail"; 
dataGridView1.Columns[11].HeaderText = "Üyeliğiniz Varmı?"; 
dataGridView1.Columns[12].HeaderText = "Üyelik Başlangış Tarihiniz"; 
}
private void button5_Click(object sender, EventArgs e) 
{ 
dtst.Tables["okuyucubil"].Clear(); 
this.Close(); 
}
private void button3_Click(object sender, EventArgs e) 
{
frm12.ShowDialog(); 
}
private void button2_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) 
{ 
bag.Open(); 
kmt.Connection = bag; 
kmt.CommandText = "DELETE from okuyucubil WHERE Tc_No=’" + silinecek + "’"; 
kmt.ExecuteNonQuery(); 
kmt.Dispose(); 
bag.Close(); 
dtst.Tables["okuyucubil"].Clear(); 
göster2(); 
} 
} 
catch 
{ ;} 
}
private void button1_Click(object sender, EventArgs e) 
{ 
frm11.ShowDialog(); 
}
private void textBox1_TextChanged(object sender, EventArgs e) 
{ 
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From okuyucubil", bag); 
if (textBox1.Text == "") 
{ 
kmt.Connection = bag; 
kmt.CommandText = "Select * from okuyucubil"; 
adtr.SelectCommand = kmt; 
adtr.Fill(dtst, "okuyucubil"); 
} 
if (Convert.ToBoolean(bag.State) == false) 
{ 
bag.Open(); 
} 
adtr.SelectCommand.CommandText = " Select * From okuyucubil" + 
" where(Adi_Syd like ‘%" + textBox1.Text + "%’ )"; 
dtst.Tables["okuyucubil"].Clear(); 
adtr.Fill(dtst, "okuyucubil"); 
bag.Close(); 
}
private void textBox2_TextChanged(object sender, EventArgs e) 
{ 
OleDbDataAdapter adtr = new OleDbDataAdapter("select * From okuyucubil", bag); 
if (textBox2.Text == "") 
{ 
kmt.Connection = bag; 
kmt.CommandText = "Select * from okuyucubil"; 
adtr.SelectCommand = kmt; 
adtr.Fill(dtst, "okuyucubil"); 
} 
if (Convert.ToBoolean(bag.State) == false) 
{ 
bag.Open(); 
} 
adtr.SelectCommand.CommandText = " Select * From okuyucubil" + 
" where(Dogm_Yeri like ‘%" + textBox2.Text + "%’ )"; 
dtst.Tables["okuyucubil"].Clear(); 
adtr.Fill(dtst, "okuyucubil"); 
bag.Close(); 
}
private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e) 
{ 
frm12.textBox1.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString(); 
frm12.textBox2.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString(); 
frm12.textBox3.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString(); 
frm12.textBox4.Text = dataGridView1.CurrentRow.Cells[5].Value.ToString(); 
frm12.textBox5.Text = dataGridView1.CurrentRow.Cells[6].Value.ToString(); 
frm12.textBox6.Text = dataGridView1.CurrentRow.Cells[7].Value.ToString(); 
frm12.textBox7.Text = dataGridView1.CurrentRow.Cells[8].Value.ToString(); 
frm12.textBox8.Text = dataGridView1.CurrentRow.Cells[9].Value.ToString(); 
frm12.textBox9.Text = dataGridView1.CurrentRow.Cells[10].Value.ToString(); 
frm12.textBox10.Text = dataGridView1.CurrentRow.Cells[11].Value.ToString(); 
frm12.textBox11.Text = dataGridView1.CurrentRow.Cells[12].Value.ToString(); 
} 
} 
}
[/code]

FORM11 İç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 Ayca_Kahraman 
{ 
public partial class Form11 : Form 
{ 
public Form3 frm3; 
public Form4 frm4; 
public Form5 frm5; 
public Form6 frm6; 
public Form8 frm8; 
public Form9 frm9; 
public Form10 frm10; 
public Form7 frm7; 
public Form12 frm12; 
public Form11() 
{ 
InitializeComponent();
}
private void Form11_Load(object sender, EventArgs e) 
{ 
frm10.combo2(); 
}
private void button1_Click(object sender, EventArgs e) 
{ 
if (textBox1.Text != "") 
{ 
frm10.bag.Open(); 
frm10.kmt.Connection = frm10.bag; 
frm10.kmt.CommandText = "INSERT INTO okuyucubil(Tc_No,Adi_Syd,Snf,Okulno,Dogm_Yeri,Dogm_Trh,Cnsyt,Adres,Ev_Tel,Cep_Tel,E_Mail,Üyelik_Var,Üyelk_Tar) VALUES (‘" + textBox1.Text + "’,’" + textBox2.Text + "’,’" + comboBox1.Text + "’,’" + textBox3.Text + "’,’" + comboBox2.Text + "’,’" + textBox4.Text + "’,’" + textBox5.Text + "’,’" + textBox6.Text + "’,’" + textBox7.Text + "’,’" + textBox8.Text + "’,’" + textBox9.Text + "’,’" + textBox10.Text + "’,’" + textBox11.Text + "’) "; 
frm10.kmt.ExecuteNonQuery(); 
frm10.kmt.Dispose(); 
frm10.bag.Close(); 
textBox1.Clear(); textBox2.Clear(); textBox3.Clear(); textBox4.Clear(); 
textBox5.Clear(); textBox6.Clear(); textBox7.Clear(); textBox8.Clear(); 
textBox9.Clear(); textBox10.Clear(); textBox11.Clear();
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 = ""; 
} 
frm10.dtst.Tables["okuyucubil"].Clear(); 
frm10.göster2(); 
frm10.combo2(); 
MessageBox.Show("Kayıt işlemi tamamlandı !");
} 
}
private void button2_Click(object sender, EventArgs e) 
{ 
this.Close(); 
} 
} 
}
[/code]

FORM12 İçerisine Yazılacak Kodlar…

[code language=”CSharp”] 
public partial class Form12 : Form 
{ 
public Form3 frm3; 
public Form4 frm4; 
public Form5 frm5; 
public Form6 frm6; 
public Form7 frm7; 
public Form8 frm8; 
public Form9 frm9; 
public Form10 frm10; 
public Form11 frm11; 
public Form12() 
{ 
InitializeComponent(); 
}
private void button2_Click(object sender, EventArgs e) 
{ 
this.Close(); 
}
private void button1_Click(object sender, EventArgs e) 
{ 
try 
{ 
frm10.bag.Open(); 
frm10.kmt.Connection = frm10.bag; 
frm10.kmt.CommandText = "UPDATE okuyucubil SET Tc_No=’" + textBox1.Text + "’,Adi_Syd=’" + textBox2.Text + "’,Snf=’" + comboBox1.Text + "’,Okulno=’" + textBox3.Text + "’,Dogm_Yeri=’" + comboBox2.Text + "’,Dogm_Trh=’" + textBox4.Text + "’,Cnsyt=’" + textBox5.Text + "’,Adres=’" + textBox6.Text + "’,Ev_Tel=’" + textBox7.Text + "’,Cep_Tel=’" + textBox8.Text + "’,E_Mail=’" + textBox9.Text + "’,Üyelik_Var=’" + textBox10.Text + "’,Üyelk_Tar=’" + textBox11.Text + "’ WHERE Üye_Adi=’" + frm10.dataGridView1.CurrentRow.Cells[0].Value.ToString() + "’"; 
frm10.kmt.ExecuteNonQuery(); 
frm10.kmt.Dispose(); 
frm10.bag.Close(); 
frm10.dtst.Tables["okuyucubil"].Clear(); 
frm10.göster2(); 
this.Close(); 
} 
catch 
{ 
; 
} 
} 
} 
[/code]

FORM13 İçerisine Yazılacak Kodlar…

[code language=”CSharp”] 
public partial class Form14 : Form 
{ 
public Form3 frm3; 
public Form14() 
{ 
InitializeComponent(); 
}
private void button1_Click_1(object sender, EventArgs e) 
{ 
openFileDialog1.ShowDialog(); 
axWindowsMediaPlayer1.URL = openFileDialog1.FileName; 
} 
}
[/code]

FORM14 İçerisine Yazılacak Kodlar…

[code language=”CSharp”] 
public partial class Form15 : Form 
{ 
public Form3 frm3; 
public Form15() 
{ 
InitializeComponent(); 
}
private void Form15_Load(object sender, EventArgs e) 
{ 
webBrowser1.Navigate("www.gorselprogramlama.com"); 
} 
} 
[/code]

Projeyi İNDİR

Yorumlar 56

Acill

27 Mayıs 2015 - 09:21

iyi günler programda üyeler dedigimde veri tabanındaki isimleri göstermesi gerekiyor ama tıkladıgımda hata veriyor ” ‘Microsoft.Jet.Oledb.4.0’ sağlayıcısı yerel makine kayıtlı değil. ” bu hatayı alıyorum daha önceki pc m de acmıstım programınızı bi şekilde yardımcı olurmusunuz
admin

27 Mayıs 2015 - 19:48

Acill :
Access versiyon sorunu olabilir.Eğer Access 2007 ,2010 veya 2013 kullanıyorsan access 2003 kurmalısın veya kodlarda jet yerine ace , 4.0 yerine 12.0 ve veri tabanı ismi data.accdb olmalı.Tabi veri tabanını 2007 veya 2010 veya 2013′te açıp 2007 ,2010 veya 2013 olarak kaydetmelisin.Veri tabanı bin–>debug klasöründe.
Gerekli

03 Ocak 2016 - 15:23

iyi günler kullanıcı adı ve şifre isteniyor
yardımcı olurmusunuz?
admin

05 Ocak 2016 - 15:11

gerekli :
Kulanıcı adı : admin
Şifre : admin
alper

14 Mart 2017 - 20:10

internet sayfasını projeden nasıl silebiliriz
admin

16 Mart 2017 - 17:24

alper :
sln uzantılı dosyayı açıp mouse seçtikten sonra delete tuşuna bas