How to filter date and time from slq server 2012 and VB.NET using a datagridview and two datetimepickers

Question

0.00/5 (No votes)

See more:

Hello all,

By any chance, does anyone have a code to filter by date and time using sql server 2012 and vb.net, this information will be display on a datagridview and I will be using to datetimepickers to filter the date. The information is saved in the db with datetime and is saved like this "07/25/2017 2:32.00"

Any help will be very much appreciated.

Thanks,

What I have tried:

I have tried different codes but no success. I'm just wondering if somebody has any idea or a code that I can try.

Posted 25-Jul-17 10:35am

Ivan Umaña

Updated 27-Jul-17 23:49pm

Add a Solution

Comments

David_Wimbley 25-Jul-17 21:54pm

We don't know enough about how you are getting the data. Are you using entity framework? ado.net/sql scripts from code?

Karthik_Mahalingam 26-Jul-17 1:10am

Use Improve question to add more info to the question.

1 solution

Add a Solution

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

ashokmaurya786 · Answer 1 · 2017-07-27T23:49:00

Solution 1

you can convert your datetime column and then filter your records.

SQL

select * from tablename
WHERE  CONVERT(VARCHAR,[Datecolumn],103) <= CONVERT(VARCHAR,@param,103)

Posted 27-Jul-17 23:49pm

ashokmaurya786

Updated 28-Jul-17 0:01am

v4

How to filter date and time from slq server 2012 and VB.NET using a datagridview and two datetimepickers

1 solution

Solution 1

Add your solution here

Preview 0

How to filter date and time from slq server 2012 and VB.NET using a datagridview and two datetimepickers

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us