search วันเดือนปี ไม่ขึ้นครับ รบกวนช่วยด้วยครับ ปวดหัวหลายวันแล้วครับ

                connection.Open();
                OleDbCommand command = new OleDbCommand("select Date_begin from Borlist where Date_begin>=" + dateTimePicker1.Value.ToString("dd/MM/yyyy hh:mm:ss") + "  and Date_begin<=" + dateTimePicker2.Value.ToString("dd/MM/yyyy hh:mm:ss") + "", connection);
                //command.ExecuteNonQuery();
                DataTable dt1 = new DataTable();
                OleDbDataAdapter da1 = new OleDbDataAdapter(command);
                da1.Fill(dt1);
                dataGridView2.DataSource = dt1;
connection.Close();

connection.Open();
OleDbCommand command = new OleDbCommand("select Date_begin from Borlist where Date_begin>='" + dateTimePicker1.Value.ToString("dd/MM/yyyy hh:mm:ss") +  "'", connection);
//command.ExecuteNonQuery();
DataTable dt1 = new DataTable();
OleDbDataAdapter da1 = new OleDbDataAdapter(command);
da1.Fill(dt1);
dataGridView2.DataSource = dt1;
connection.Close();

connection.Open();
OleDbCommand command = new OleDbCommand("select Date_begin from Borlist where Date_begin <='" + dateTimePicker2.Value.ToString("dd/MM/yyyy hh:mm:ss") + "'", connection);
//command.ExecuteNonQuery();
DataTable dt1 = new DataTable();
OleDbDataAdapter da1 = new OleDbDataAdapter(command);
da1.Fill(dt1);
dataGridView2.DataSource = dt1;
connection.Close();

DataTable dt = new DataTable();
string connectionString = "up to you";

using (OleDbConection connection = new OleDbConection(connectionString))
using (OleDbCommand command = connection.CreateCommand())
{
   StringBuilder commandString = new StringBuilder();
   commandString.AppendLine("SELECT Date_begin");
   commandString.AppendLine("FROM Borlist");
   commandString.AppendLine("WHERE Date_begin BETWEEN @Start AND @End;");

   command.CommandTimeout = 30;
   command.CommandType = CommandType.Text;
   command.CommandText = commandString.ToString();
   command.Parameters.AddWithValue("@Start", this.dateTimePicker1.Value.Date);
   command.Parameters.AddWithValue("@End", this.dateTimePicker2.Value.Date);

   using (OleDbDataAdapter adapter = new OleDbDataAdapter())
   {
      adapter.SelectCommand = command;
      adapter.Fill(dt);
   }
}

this.dataGridView2.DataSource = dt;

public static System.Data.DataTable GetTableForm(string strConn,DateTime dtStart,DateTime dtFinal)

        {
            System.Data.DataSet ds = new System.Data.DataSet();
             string _SQL "WHERE Date_begin BETWEEN '" + dtStart + "' AND '" + dtFinal + "'" ;
                    System.Data.OleDb.OleDbConnection conn2 = new  System.Data.OleDb.OleDbConnection(strConn);
                    conn2.Open();
                    System.Data.OleDb.OleDbDataAdapter adapter2 = new  System.Data.OleDb.OleDbDataAdapter(_SQL,  conn2);
                    return ds.Tables[0];
        }

DataTable dt = new DataTable();
                connection.Open();

                using (OleDbCommand command = connection.CreateCommand())
                {
                    StringBuilder commandString = new StringBuilder();
                    commandString.AppendLine("SELECT bl.Borrow_id,bl.Date_begin,bc.Id_card,c.Sname,c.Tel,t.Type_name,t.Percen,t.Type,bc.Weight,r.Duration,r.Rate,bl.Babout_cost,r.R_ID,bl.Date_receive,r.Date");
                    commandString.AppendLine("FROM Borcus bc,Borlist bl,Custumer c,Type t,Rate r");
                    commandString.AppendLine("WHERE bc.Borrow_id=bl.Borrow_id and bc.Id_card=c.Id_card and bc.Type_id=t.Type_id and bl.R_ID=r.R_ID and bl.P_no='01' AND Date_begin BETWEEN @Start AND @End;");

                    //command.CommandTimeout = 30;
                    command.CommandType = CommandType.Text;
                    command.CommandText = commandString.ToString();
                    command.Parameters.AddWithValue("@Start", this.dateTimePicker1.Value.ToShortDateString());
                    command.Parameters.AddWithValue("@End", this.dateTimePicker2.Value.ToShortDateString());

                    using (OleDbDataAdapter adapter = new OleDbDataAdapter())
                    {
                        adapter.SelectCommand = command;
                        adapter.Fill(dt);
                    }
                    this.dataGridView2.DataSource = dt;
                    dataGridView2.Columns["Duration"].Visible = false;
                    dataGridView2.Columns["Rate"].Visible = false;
                    dataGridView2.Columns["R_ID"].Visible = false;
                    dataGridView2.Columns["Date_receive"].Visible = false;
                    dataGridView2.Columns["Date"].Visible = false;

                    string[] header = { "เลขที่สัญญา", "วันที่ทำสัญญา", "เลขบัตร ปชช.", "ชื่อลูกค้า", "เบอร์โทรศัพท์", "ชนิดสินค้า", "เปอร์เซ็นต์ %", "ประเภท", "น้ำหนัก" };
                    for (int i = 0; i < header.Length; i++)
                    {
                        dataGridView2.Columns[i].HeaderText = header[i];
                    }
                }
                connection.Close();