Revisions to Read data from sql database using datetime picker

added 1 characters in body

edited Feb 2, 2013 at 9:48

7.1k
5
31
46

Try move a one space near at your "%) and I corrected the query. Try to figure out.

Dim strSQL As String = "SELECT EMP_ID,EMP_NAME,AT_STATUS, " + _ "AT_REMARK FROM ATTENDANCE " + _ "WHERE Convert(Varchar(10), AT_DATE, 23) = " + _ "('" & editdate.ToString("yyyy-MMM-dd") & "') ORDER BY EMP_NAME ASC"

Try move a one space near at your "%) and I corrected the query. Try to figure out.

Dim strSQL As String = "SELECT EMP_ID,EMP_NAME,AT_STATUS, " + _ "AT_REMARK FROM ATTENDANCE " + _ "WHERE Convert(Varchar(10), AT_DATE, 23) = " + _ "('" & editdate.ToString("yyyy-M-dd") & "') ORDER BY EMP_NAME ASC"

Try move a one space near at your "%) and I corrected the query. Try to figure out.

Dim strSQL As String = "SELECT EMP_ID,EMP_NAME,AT_STATUS, " + _ "AT_REMARK FROM ATTENDANCE " + _ "WHERE Convert(Varchar(10), AT_DATE, 23) = " + _ "('" & editdate.ToString("yyyy-MM-dd") & "') ORDER BY EMP_NAME ASC"

deleted 2 characters in body

Source Link

edited Feb 2, 2013 at 9:34

spajce

7.1k
5
31
46

Try move a one space near at your "%) and I corrected the query. Try to figure out.

Dim strSQL As String = "SELECT EMP_ID,EMP_NAME,AT_STATUS, " + _ "AT_REMARK FROM ATTENDANCE " + _ "WHERE Convert(Varchar(10), OrderDateAT_DATE, 23) = " + _  "('" & editdate.ToString("yyy"yyyy-mmM-dd") & "') ORDER BY EMP_NAME ASC"

Try move a one space near at your "%) and I corrected the query. Try to figure out.

Dim strSQL As String = "SELECT EMP_ID,EMP_NAME,AT_STATUS, " + _ "AT_REMARK FROM ATTENDANCE " + _ "WHERE Convert(Varchar(10), OrderDate, 23) = ('" & editdate.ToString("yyy-mm-dd") & "') ORDER BY EMP_NAME ASC"

Try move a one space near at your "%) and I corrected the query. Try to figure out.

Dim strSQL As String = "SELECT EMP_ID,EMP_NAME,AT_STATUS, " + _ "AT_REMARK FROM ATTENDANCE " + _ "WHERE Convert(Varchar(10), AT_DATE, 23) = " + _  "('" & editdate.ToString("yyyy-M-dd") & "') ORDER BY EMP_NAME ASC"

edited body

Source Link

edited Feb 2, 2013 at 9:20

spajce

7.1k
5
31
46

Try move a one space near at your "%) and I corrected the query. Try to figure out.

Dim strSQL As String = "SELECT EMP_ID,EMP_NAME,AT_STATUS, " + _ "AT_REMARK FROM ATTENDANCE " + _ "WHERE CASTConvert(AT_DATEVarchar(10), ASOrderDate, Date23) = ('" & editdate.ToString("YYY"yyy-mm-dd") & "') ORDER BY EMP_NAME ASC"

Try move a one space near at your "%) and I corrected the query. Try to figure out.

Dim strSQL As String = "SELECT EMP_ID,EMP_NAME,AT_STATUS, " + _ "AT_REMARK FROM ATTENDANCE " + _ "WHERE CAST(AT_DATE AS Date) = ('" & editdate.ToString("YYY-mm-dd") & "') ORDER BY EMP_NAME ASC"

Try move a one space near at your "%) and I corrected the query. Try to figure out.

Dim strSQL As String = "SELECT EMP_ID,EMP_NAME,AT_STATUS, " + _ "AT_REMARK FROM ATTENDANCE " + _ "WHERE Convert(Varchar(10), OrderDate, 23) = ('" & editdate.ToString("yyy-mm-dd") & "') ORDER BY EMP_NAME ASC"