how to solver the datetimekeper condition

Question

0.00/5 (No votes)

See more:

Hi,

Dear Experts I want to ask a question

This Query is working fine.

C#

string query = "select txtDate,txtCustomerName,txtAddress from EntryTable where txtCustomerName='" + txtCustomerName.Text + "' AND txtDate >= '" + Convert.ToDateTime(dateTimePicker1.Value) + " ' AND txtDate <= '" + Convert.ToDateTime(dateTimePicker2.Value) + "' ";

But I have some problem when i am not selecting any date from the datetimepicker (1& 2) means equal date (like 17.9.2013 in datetimepicker1 and 17.9.2013 in datetimepicker2) Its not find any data of this date.
if I am selecting in datetimekeper1 “16.9.2013 “ then all the data displayed.

Please tell me what is the condition will be put in the query.

Posted 17-Sep-13 0:58am

indiancodinglove

Updated 17-Sep-13 1:04am

Tadit Dash (ତଡିତ୍ କୁମାର ଦାଶ)

v3

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

**Joezer BH** · Accepted Answer · 2013-09-17T01:11:00

Solution 1

Your date is all set for this one day, that's true, but it contains more than the date, it also contains the time! so comparing using both will result only in those entries which were inserted in the exact time point which probably returns nothing...

If you want all entries of the day, in your example it is 17.9.2013, make sure the dateTimePicker1.Value after converted, has the day's very first time value of 00:00:00
and the dateTimePicker2.Value, after converted, has the largest time value of 23:59:59.997

before you use the datetime in your query set the TIME,
Example:

C#

// use dt1 instead of the dateTimePicker1.Value (and the same for dt2)
Datetime dt1 = dateTimePicker1.Value.Date.AddHours(0).AddMinutes(0).AddSeconds(0);
Datetime dt2 = dateTimePicker2.Value.Date.AddHours(23).AddMinutes(59).AddSeconds(59);

Cheers,
Edo

Posted 17-Sep-13 1:11am

Joezer BH

Updated 17-Sep-13 2:54am

v6

Comments

indiancodinglove 17-Sep-13 7:52am

now i am use this query its give me right result is it ok?

string dt1 = dateTimePicker1.Value.ToString("yyyy.MM.dd");
string dt2 = dateTimePicker2.Value.ToString("yyyy.MM.dd");
string query = "select txtDate,txtCustomerName,txtAddress from EntryTable where Convert(varchar(10),txtDate,102) between '" + dt1 + "' and '" + dt2 + "'";

Joezer BH 17-Sep-13 8:09am

No, you still need to set the TIME, not only the date

indiancodinglove 17-Sep-13 8:18am

Sir Please tell me how to set the time.

Joezer BH 17-Sep-13 8:33am

See updated solution with editing the Time values of a Datetime struct

indiancodinglove 17-Sep-13 8:51am

It Gives a error

"Property or indexer 'System.DateTime.Hour' cannot be assigned to -- it is read only"

Joezer BH 17-Sep-13 8:55am

You are right! I've updated with a much simpler approach and code :)

indiancodinglove 17-Sep-13 9:08am

it show the empty grid view (same date or selected different date)

Joezer BH 17-Sep-13 9:14am

And you have records matching that day?

indiancodinglove 17-Sep-13 9:18am

Yes sir its my mistake its working fine.

Thanks a Lot sir.

Joezer BH 17-Sep-13 9:20am

You are most welcome :)