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; 
  using System.Data.OleDb; 
  namespace veritabanıişlemlerii 
  { 
      public partial class Form1 : Form 
      { 
          public Form1() 
          { 
              InitializeComponent(); 
          } 
   
          private void Form1_Load(object sender, EventArgs e) 
          { 
              hallet(); 
          } 
          OleDbCommand komut = new OleDbCommand(); 
          OleDbConnection bag = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=database.accdb"); 
          DataSet tut = new DataSet(); 
          public void hallet()  
          { 
               
              bag.Open(); 
              OleDbDataAdapter ap = new OleDbDataAdapter("Select * From ogrenci_kyt", bag); 
              ap.Fill(tut, "ogrenci_kyt"); 
              dataGridView1.DataSource = tut; 
              dataGridView1.DataMember = "ogrenci_kyt"; 
              bag.Close(); 
              ap.Dispose(); 
          } 
          private void button1_Click(object sender, EventArgs e) 
          { 
              string ekle = "INSERT INTO ogrenci_kyt(Ogrenci_adi,Ogrenci_soyadi,Ogrenci_tc_n'su,Ogrenci_okul_n'su,Ogrenci_kayit_tarihi) VALUES ('" + textBox1.Text + "','" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "','" + textBox5.Text + "')"; 
              bag.Open(); 
              komut.Connection = bag; 
              komut.CommandText = ekle; 
              komut.ExecuteNonQuery(); 
              bag.Close(); 
              komut.Dispose(); 
              tut.Clear(); 
               
               
          } 
      } 
  }