Tech
Forums
Jobs
Books
Events
Interviews
Live
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
6
Reply
C# searching a Access Database
james james
Nov 3 2017 10:08 AM
183
Reply
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();
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
6
)
Next Recommended Forum
Microsoft.AspNet.SignalR.JS 2.2.2' to 'Microsoft.AspNet.Sign
Using return true and false