如何将今天的日期与Excel日期列进行比较以便在C＃中显示当前输入的数据＃

Question

我需要将今天的日期与Excel中的日期进行比较，以便它显示今天在DataGridView中输入的所有数据。我尝试了很多代码迭代，但仍然收到错误，有些不显示所需的结果。这里是代码：

private void todayToolStripMenuItem_Click(object sender, EventArgs e) 
    { 

     int day = todaysDate.Day ; 
     int month =todaysDate.Month; 
     MessageBox.Show("Month" + month+ "Date" + day, "abc", MessageBoxButtons.OK); 
     int year = todaysDate.Year; 

     String name = "Sheet1"; 
     OleDbConnection con = new OleDbConnection(constr); 
     OleDbCommand oconn = new OleDbCommand("Select * From [" + name + "$] WHERE Date CONTAINS " + day + "AND Date CONTAINS " + month + 
      "AND Date CONTAINS " + year, con); 

     try 
     { 
      con.Open(); 
     } 
     catch (Exception) 
     { 

     } 

     OleDbDataAdapter sda = new OleDbDataAdapter(oconn); 
     DataTable data = new DataTable(); 
     sda.Fill(data); 
     dataGridView1.DataSource = data; 
    } 

在此先感谢。

Answer 1

已更新 使用带参数的查询而不是将值注入到字符串中。这是对我工作的罚款：

OleDbCommand oconn = new OleDbCommand("Select * From [Sheet1$] WHERE Date = @date"); 
oconn.Connection = connection; 
try 
{ 
    oconn.Parameters.AddWithValue("@date", DateTime.Now.ToString("MM/dd/yyyy")); 
    connection.Open(); 
    OleDbDataAdapter sda = new OleDbDataAdapter(oconn); 
    DataTable data = new DataTable(); 
    sda.Fill(data); 
    connection.Close(); 
} 
catch (Exception) 
{ 

}