C# searching a Access Database

james james

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();

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

james james8y ago
Rajkiran
When I use break points i get no errors it in fact deletes the entry i am searching for.
Rajkiran Swain8y ago
Put the break point and check in which line you are gettin the null value .
james james8y ago
I dont have a DataGrid does not contain a definition for DataBind.
Gokulraj Sankar8y ago
Hi,

Replace the below code in your button click event.

OleDbConnection con = new OleDbConnection();
con.ConnectionString = ConfigurationManager.ConnectionStrings["Connection"].ToString();
con.Open();
OleDbCommand cmd = new OleDbCommand("Select * from Sheet1 WHERE ToDay like ('" + txt_Date.Text + "*')",con);
OleDbDataAdapter olda = new OleDbDataAdapter(cmd);
DataTable dt = new DataTable();
olda.Fill(dt);
dataGrid.DataBind();
james james8y ago
gokul

that didnt work when I click the button nothing happeds.
Gokulraj Sankar8y ago
Hi,

replace the below query

Select * from Sheet1 WHERE ToDay like ('" + txt_Date.Text + "*')

Replace '%' to '*'

hope this helps you!.