DataBinding Filter with DateTimePacker

Question

0.00/5 (No votes)

See more:

Hello
I need help
I make small program but the problem in filter data in datagridview
I use databinding with datetimepacker (I need data between tow dates)

VB

Dim T1 As Date
Dim T2 As Date
T1 = Convert.ToDateTime(Me.DateTimePicker1.Value)
T2 = Convert.ToDateTime(Me.DateTimePicker2.Value)
Me.T1BindingSource.Filter = "_Date >= #T1#  AND _Date <= #T2#"

but there is an error
The string was not recognized as a valid DateTime. There is a unknown word starting at index 0.
can anyone help me ?

Posted 5-Jan-13 10:54am

KosayHatem

Updated 5-Jan-13 10:57am

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)

Sandeep Mewara · Answer 1 · 2013-01-05T22:32:00

The string was not recognized as a valid DateTime. There is a unknown word starting at index 0.
To start with, it looks like one of the code lines like

C#

Convert.ToDateTime(Me.DateTimePicker1.Value)

is throwing the same. Based on error, the value is either empty or not in a format that can be converted into a Datetime.
Make sure, you have a valid datetime value for conversion.

Moving ahead, the filter criteria formed should be proper as expected. Use VS DEBUGGER to track and see the workflow and values.