Notes

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; //Acces bağlantı dosyaları

namespace WindowsFormsApp4
{
public partial class Form1 : Form
{
//Veri Tabanı Değişkenlerini Tanımlama Bölümü
OleDbConnection baglanti = new OleDbConnection(“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=okul.accdb”);
OleDbCommand komut = new OleDbCommand();
OleDbDataAdapter adtr = new OleDbDataAdapter();
DataSet ds = new DataSet();

public Form1()
{

InitializeComponent();
}

//DataGridWiev de kayıtları listeleme bölümü
void listele()
{

baglanti.Open();
OleDbDataAdapter adtr = new OleDbDataAdapter(“Select * from ogrenci”, baglanti);
adtr.Fill(ds, “ogrenci”);
dataGridView1.DataSource = ds.Tables[“ogrenci”];
adtr.Dispose();
baglanti.Close();
}

private void button3_Click(object sender, EventArgs e)
{

if (textBox3.Text != “” && textBox4.Text != “” && textBox5.Text != “” && textBox6.Text != “”)
{
komut.Connection = baglanti;
komut.CommandText = “Insert Into ogrenci(ogr_no,ogr_ad,ogr_soyad,ogr_tel) Values (‘” + textBox3.Text + “‘,'” + textBox4.Text + “‘,'” + textBox5.Text + “‘,'” + textBox6.Text + “‘)”;
baglanti.Open();
komut.ExecuteNonQuery();
komut.Dispose();
baglanti.Close();
MessageBox.Show(“Kayıt Tamamlandı!”);
ds.Clear();
listele();
}
else
{
MessageBox.Show(“Boş alan geçmeyiniz!”);
}
}

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

}

private void button1_Click(object sender, EventArgs e)
{
DialogResult c;
c = MessageBox.Show(“Silmek istediğinizden emin misiniz?”, “Uyarı!”, MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (c == DialogResult.Yes)
{
baglanti.Open();
komut.Connection = baglanti;
komut.CommandText = “Delete from ogrenci where ogr_no=” + textBox1.Text + “”;
komut.ExecuteNonQuery();
komut.Dispose();
baglanti.Close();
ds.Clear();
listele();
}
}

private void dataGridView1_CellEnter(object sender, DataGridViewCellEventArgs e)
{
textBox3.Text = dataGridView1.CurrentRow.Cells[0].Value.ToString();
textBox4.Text = dataGridView1.CurrentRow.Cells[1].Value.ToString();
textBox5.Text = dataGridView1.CurrentRow.Cells[2].Value.ToString();
textBox6.Text = dataGridView1.CurrentRow.Cells[3].Value.ToString();
}

private void button2_Click(object sender, EventArgs e)
{
baglanti = new OleDbConnection(“Provider=Microsoft.ACE.Oledb.12.0;Data Source=okul.accdb”);
adtr = new OleDbDataAdapter(“SElect *from ogrenci where ogr_no like ‘” + textBox2.Text + “%'”, baglanti);
ds = new DataSet();
baglanti.Open();
adtr.Fill(ds, “ogrenci”);
dataGridView1.DataSource = ds.Tables[“ogrenci”];
baglanti.Close();
}

private void button4_Click(object sender, EventArgs e)
{
komut = new OleDbCommand();
baglanti.Open();
komut.Connection = baglanti;
komut.CommandText = “update ogrenci set ogr_ad='” + textBox4.Text + “‘, ogr_soyad='” + textBox5.Text + “‘, ogr_tel='” + textBox6.Text + “‘ where ogr_no=” + textBox3.Text + “”;
komut.ExecuteNonQuery();
baglanti.Close();
ds.Clear();
listele();
}

private void button5_Click(object sender, EventArgs e)
{
dataGridView1.Rows.RemoveAt(dataGridView1.SelectedRows[0].Index);

}

int seçilensatır;

private void dataGridView1_RowEnter(object sender, DataGridViewCellEventArgs e)
{
seçilensatır = Convert.ToInt16(ds.Tables[“ogrenci”].Rows[e.RowIndex][“Kimlik”]);

textBox3.Text = seçilensatır.ToString();

textBox4.Text = ds.Tables[“ogrenci”].Rows[e.RowIndex][“ogr_no”].ToString();
textBox5.Text = ds.Tables[“ogrenci”].Rows[e.RowIndex][“ogr_ad”].ToString();
textBox6.Text = ds.Tables[“ogrenci”].Rows[e.RowIndex][“ogr_soyad”].ToString();

}

private void dataGridView1_CellContentClick(object sender, DataGridViewCellEventArgs e)
{

}

private void dataGridView1_RowEnter_1(object sender, DataGridViewCellEventArgs e)
{
textBox3.Text = ds.Tables[“ogrenci”].Rows[e.RowIndex][“ogr_no”].ToString();

textBox4.Text = ds.Tables[“ogrenci”].Rows[e.RowIndex][“ogr_ad”].ToString();
textBox5.Text = ds.Tables[“ogrenci”].Rows[e.RowIndex][“ogr_soyad”].ToString();
textBox6.Text = ds.Tables[“ogrenci”].Rows[e.RowIndex][“ogr_tel”].ToString();
}
}
}