Date select option from one column

Shovan Saha

string sql = "SELECT * FROM LalData WHERE PaymentDate between '"+ dtpStartDate.Value.AddDays(-1).ToString() + "' AND '" + dtpEndDate.Value.ToString()+"'";

I need data from start date but when I select a date from datetimepicker, that takes the value from the next day. That is why, I used AddDays(-1). But it is well for within any month. When I select two days from two datetimepicker for two month but it does not work. Can anyone help me?

2 Replies

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

Nilesh Shah9y ago
Accepted answer
Did you put a debug point on this line and checked what is the value of the "sql" string?

Ideally you shold be able to run that "Sql" string as a query as it is in SQL Server.

First try to fix it. Until you are not able to get the result in SQL this way, your code will not work.

I suspect here the Value.toString() is producing some date with unexpected format or with date time and seconds fractions.

try to create date in YYYY-MM-DD format from the datepicker first.
Shovan Saha9y ago
Dear Sir, How can I get data of selected date? I always get the between value. If i use AddDays(-1) and select 1st date of any month, I get previous month's data. I do not use sql server here. It is desktop application with access database. I am new in C#.

private void btnSearch_Click(object sender, EventArgs e)
{

con = new OleDbConnection(conString);

string sql = "SELECT * FROM LalData WHERE PaymentDate between '"+ dtpStartDate.Value.AddDays(-1).ToString() + "' AND '" + dtpEndDate.Value.ToString()+"'";

con.Open();
adapter = new OleDbDataAdapter(sql, con);
dt = new DataTable();
adapter.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.CurrentCell = dataGridView1.Rows[dataGridView1.Rows.Count - 1].Cells[0];

btnSubmit.Enabled = false;

}