数据未在DGV中显示(VB.net和SQL Server) [英] Data not showing in DGV (VB.net & SQL Server)
问题描述
您好!
我使用的是VB.net 2005和MS SQL Server 2005
所以我尝试在sql中执行此代码:
SELECT queueno,plateno, CONVERT ( varchar ( 10 ),qdate, 101 ) AS DateToday
FROM dbo.TRN_Queue
WHERE ( CONVERT ( varchar ( 10 ),qdate, 101 )= ' 05/14/2014')
和它给我这张桌子:
queueno platenumber DateToday
1G001 ABC123 05/14/2014
1G002 DEF456 05/14/2014
^这是我想在我的Form1中显示的表
我在VB.net中创建了一个包含Label1的表单。 Label1是今天的日期。
这是我的Lable1代码:
Label1.Text = DateTime.Now.ToString( MM / dd / yyyy)
所以它显示这个:05/14/2014
因此尝试使用Label1作为我的DGV的过滤器。我将此代码用于DGV:
SELECT queueno,plateno,CONVERT(varchar(10),qdate,101)AS DateToday FROM dbo.TRN_Queue WHERE(CONVERT(varchar(10),qdate,101)='& Label1.Text& ')
但是当我运行我的项目时,DGV是空的。
请帮助!
如果你需要获取的记录今天,更改SQL如下。请注意,我已从标签中删除了日期,SQLGETDATE
函数可用于获取当前日期。我们不需要从UI发送它。
SELECT queueno,plateno, CONVERT ( varchar ( 10 ),qdate, 101 ) AS DateToday FROM dbo.TRN_Queue WHERE CAST(qdate AS DATE )= CAST(GETDATE) () AS DATE )
或者你需要获取给定日期的记录,使用SQL参数
SELECT queueno,plateno, CONVERT ( varchar ( 10 ),qdate, 101 ) AS DateToday FROM dbo.TRN_Queue WHERE CAST(qdate AS DATE )= CAST( @ dateParam AS DATE )
然后你需要设置参数值如下
cmd.Parameters.Add( @ dateParam,SqlDbTypes.DateTime).Value = DateTime.Now
Hello!
I am using VB.net 2005 and MS SQL Server 2005
So I tried executing this code in 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:
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:
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:
"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!
If you need to get records of today, change the SQL as below. Note that I have removed taking date from label, SQLGETDATE
function can be used to get the current date. we don't need to send it from UI.
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
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
cmd.Parameters.Add("@dateParam", SqlDbTypes.DateTime).Value = DateTime.Now
这篇关于数据未在DGV中显示(VB.net和SQL Server)的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!