Data not showing in DGV (VB.net & SQL Server)

Question

5.00/5 (1 vote)

See more:

Hello!
I am using VB.net 2005 and MS SQL Server 2005

So I tried executing this code in sql:

SQL

SELECT     queueno, plateno, CONVERT(varchar(10), qdate, 101) AS DateToday
FROM         dbo.TRN_Queue
WHERE     (CONVERT(varchar(10), qdate, 101) = '05/14/2014')

and its giving me this table:

PHP

queueno     platenumber     DateToday
1G001         ABC123        05/14/2014
1G002         DEF456        05/14/2014

^This is the table i want to show in my Form1

I created a form in VB.net that contains Label1. Label1 is the date today.
This is my code for Lable1:

VB

Label1.Text = DateTime.Now.ToString("MM/dd/yyyy")

so it shows this: 05/14/2014

So tried using Label1 as filter for my DGV. and i used this code for DGV:

VB

"SELECT queueno, plateno, CONVERT(varchar(10), qdate, 101) AS DateToday FROM dbo.TRN_Queue WHERE (CONVERT(varchar(10), qdate, 101) = '" & Label1.Text & "')"

But when i run my project, the DGV is empty.
Help please!

Posted 13-May-14 17:00pm

charliedev

Updated 13-May-14 17:01pm

v2

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)

DamithSL · Answer 1 · 2014-05-13T17:45:00

If you need to get records of today, change the SQL as below. Note that I have removed taking date from label, SQL GETDATE function can be used to get the current date. we don't need to send it from UI.

SQL

SELECT queueno, plateno, CONVERT(varchar(10), qdate, 101) AS DateToday FROM dbo.TRN_Queue WHERE CAST(qdate AS DATE) = CAST(GETDATE() AS DATE)

Or you need to get records for given date, use SQL parameter

SQL

SELECT queueno, plateno, CONVERT(varchar(10), qdate, 101) AS DateToday FROM dbo.TRN_Queue WHERE CAST(qdate AS DATE) = CAST(@dateParam AS DATE)

then you need to set the value of parameter as below

VB

cmd.Parameters.Add("@dateParam", SqlDbTypes.DateTime).Value = DateTime.Now