I have a Access database that i want to search by date my code returns nothing, what am I missing?
- public partial class MainWindow : Window
- {
-
-
- public MainWindow()
- {
- InitializeComponent();
- loadgrid();
- txt_Date.Clear();
-
- }
-
- private void loadgrid()
- {
- OleDbConnection con = new OleDbConnection();
- con.ConnectionString = ConfigurationManager.ConnectionStrings["Connection"].ToString();
- con.Open();
- OleDbCommand cmd = new OleDbCommand();
- cmd.CommandText = "Select * from [Sheet1]";
- cmd.Connection = con;
- OleDbDataReader rd = cmd.ExecuteReader();
- dataGrid.ItemsSource = rd;
-
- }
-
-
- private void btn_Search_Click(object sender, RoutedEventArgs e)
- {
-
- OleDbConnection con = new OleDbConnection();
- con.ConnectionString = ConfigurationManager.ConnectionStrings["Connection"].ToString();
- con.Open();
- OleDbCommand cmd = new OleDbCommand();
- cmd.CommandText = "Select * from Sheet1 WHERE ToDay like ('" + txt_Date.Text + "%')";
- cmd.Connection = con;
- OleDbDataReader rd = cmd.ExecuteReader();
- dataGrid.ItemsSource = rd;
-
- loadgrid();