Select data from Specific dates

Question

I am using MS Access as my database and c# as front end. I want to fetch data from a specific date of any month and year. I got the result only for two digit dates(10,11,12.....) but not for single digit(01,02,03,.......,09)

Here is the code

string d = dateTimePicker1.Value.Date.ToString("dd");
string constr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=|DataDirectory|\Auto_Finance.accdb;Persist Security Info=False;";
OleDbConnection con = new OleDbConnection(constr);
con.Open();
//string sql1 = @"select * from Party_Det order by PName asc where Loandate like '%'" + d + "'%' order by PName asc ";
//string sql1 = @"select * from Party_Det order by PName asc where Loandate like '*',@Loandate";// order by PName asc ";
//string sql1 = @"select * from Party_Det where Loandate like '*',@Loandate";// order by PName asc ";
string sql1 = @"select * from Party_Det where Day(Loandate)=@Loandate order by PName asc ";
OleDbCommand cmd1 = new OleDbCommand(sql1, con);
cmd1.Parameters.AddWithValue("@Loandate", d);
OleDbDataAdapter da = new OleDbDataAdapter(cmd1);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
con.Close();

Thank You

Daryl Young · Accepted Answer · 2015-04-28 04:08:08Z

1

If I understood your question correctly, you can do this:

string sql1 = @"select * from Party_Det where Day(Loandate)=@Loandate order by PName asc ";

answered Apr 28, 2015 at 4:08

Daryl Young

3943 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Select data from Specific dates

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related