ACCESS VERİ TABANINA BAĞLANMA VE KAYIT EKLEME

namespace ilkveritabani
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
        OleDbConnection bag = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0; Data Source=okul.accdb");
        OleDbCommand kmt = new OleDbCommand();
        DataTable tablo = new DataTable();
        private void Form1_Load(object sender, EventArgs e)
        {
            this.ogrbil1TableAdapter.Fill(this.okulDataSet.ogrbil);
        }
        void listele()
        {
            tablo.Clear();
            bag.Open();
            OleDbDataAdapter adtr=new OleDbDataAdapter("Select * from ogrbil",bag);
            adtr.Fill(tablo);
            dataGridView1.DataSource = tablo;
            adtr.Dispose();
            bag.Close();
        }
        private void button1_Click(object sender, EventArgs e)
        {
            bag.Open();
            kmt.Connection = bag;
            kmt.CommandText = "INSERT INTO ogrbil(nosu,adi,soyadi,sinifi) VALUES ('" + textBox1.Text + "', '" + textBox2.Text + "','" + textBox3.Text + "','" + textBox4.Text + "')";
            kmt.ExecuteNonQuery();
            kmt.Dispose();
            bag.Close();
            listele();
            textBox1.Clear();
            textBox2.Clear();
            textBox3.Clear();
            textBox4.Clear();
 }    } }