using System;
using System.Data;
using System.Data.OleDb;
using System.Windows.Forms;

namespace sorgular
{
    public partial class Form1 : Form
    {
        OleDbConnection con;
        OleDbDataAdapter da;
        DataTable dt;
        public Form1()
        {
            InitializeComponent();
        }

        void sorgugetir()
        {
            con = new OleDbConnection("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=sorgu.accdb");
            con.Open();
            da = new OleDbDataAdapter("SELECT * FROM Tablom", con);
            dt = new DataTable();
            da.Fill(dt);
            dataGridView1.DataSource = dt;
            con.Close();
        }

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

        private void button2_Click(object sender, EventArgs e)
        {
            try
            {
                if (con.State == ConnectionState.Closed) 
                {
                    con.Open();
                }

                string sql = "SELECT tc, ono, ad, soyad FROM Tablom WHERE dtarihi BETWEEN @tar1 AND @tar2";
                OleDbDataAdapter adp = new OleDbDataAdapter(sql, con);
                adp.SelectCommand.Parameters.AddWithValue("@tar1", tarih1.Value);
                adp.SelectCommand.Parameters.AddWithValue("@tar2", tarih2.Value);

                DataTable dt = new DataTable();
                adp.Fill(dt);
                dataGridView1.DataSource = dt;

                con.Close();
            }
            catch (Exception ex)
            {
                MessageBox.Show("Hata: " + ex.Message);
            }
        }

       

    }
}