以Gridview格式显示记录 [英] Display records in Gridview format

问题描述

我想显示基于今天的数据.
我在将数据显示到gridview中时出错.这是错误关键字"where"附近的语法不正确." ...
希望有人帮助我....

Hi,

I want to display the data based on today date.
I got error to display data into gridview. This is the error "Incorrect syntax near the keyword ''where''."...
Hope anybody help me....

        Dim queryString1 As String = "SELECT     A.ExitID, A.EmpNo, B.Name, A.DeptmtID, CONVERT(varchar, A.ExitTimeFrom, 103) AS ExitTimeFrom, CONVERT(varchar, A.ExitTimeTo, 103) 
                      AS ExitTimeTo, A.ExitFrom, A.ExitTo, C.ExitStatus, A.Purpose
FROM         ExitPassDetails AS A LEFT OUTER JOIN
                      CMOS.dbo.Boss_Employee_Profile AS B ON A.EmpNo = B.EmpNo LEFT OUTER JOIN
                      ExitPassStatus AS C ON A.ExitStatus = C.StatusID
WHERE     (A.ExitTimeFrom >= DATEPART(m, GETDATE()))
ORDER BY ExitTimeFrom DESC"

谢谢
BB

Thanks
BB

推荐答案

WHERE (CONVERT(varchar, A.ExitTimeFrom, 103) >=  CONVERT(varchar, GETDATE(), 103))

感谢大家..
这部分解决了..

问候
BB

Thanks everyone..
this part solved..

Regards
BB

这篇关于以Gridview格式显示记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！