// Projeye eklenmesi gereken kütüphane
using System.Data.OleDb;



// Formun Load Olayına Yazılacaklar.
private void frmMain_Load(object sender, EventArgs e)
        {
            // datagridview'e verilen çekilmesi
            OleDbConnection baglan = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0; Data Source=C:\\dbMarket.accdb");
            OleDbDataAdapter adaptor = new OleDbDataAdapter("Select * from market", baglan);
            DataSet dataset = new DataSet();

            dataset.Clear();
            adaptor.Fill(dataset, "market");
            dataGridView1.DataSource = dataset.Tables["market"];
            adaptor.Dispose();

            // Combobox'a kullanıcı adlarının eklenmesi
            OleDbConnection bag = new OleDbConnection("Provider=Microsoft.Ace.OleDb.12.0; Data Source=C:\\dbMarket.accdb");
            OleDbCommand kmt = new OleDbCommand();
            OleDbDataReader oku;

            try
            {
                cmbKullaniciAdlari.Items.Clear();
                baglan.Open();
                kmt.Connection = baglan;
                kmt.CommandText = "Select username from user";
                oku = kmt.ExecuteReader();
                while (oku.Read())
                {
                    cmbKullaniciAdlari.Items.Add(oku[0]);
                }
                baglan.Close();

            }
            catch (Exception hata)
            {
                MessageBox.Show(hata.Message, "Hata!", MessageBoxButtons.OK, MessageBoxIcon.Error);
                this.Close();
            }

        }