Select method of Dataset not working
-
Hi! I'm using Select method to return rows from dataset. The problem is when I'm using select method to return using 1 method to return data I'm getting the result but when I'm using 2 method it does not return any value. I tried seaching on Google I could not find any answer for this. timeStamp>= '08/12/2008 03:16:39' //Returns all rows timeStamp>= '08/12/2008 03:16:39' And timeStamp<= '08/12/2008 03:16:40' //This returns 0 rows //objDSVideoFile is a dataset object 1. The following returns all rows as result MFilteredRows = objDSVideoFile.Tables("ContextImage").Select("timeStamp>= '" & intStartTime & "' ") Run time value timeStamp>= '08/12/2008 03:16:39' 2. This does not return any row MFilteredRows = objDSVideoFile.Tables("ContextImage").Select("timeStamp>= '" & intStartTime & "' " & "And timeStamp<= '" & intEndTime & "'") Run time value timeStamp>= '08/12/2008 03:16:39' And timeStamp<= '08/12/2008 03:16:40' I've the (dates) values as given below including these values. Minimum value à 2008-08-12T03:16:39.468 Maximum value à 2008-08-12T03:16:56.140 Thanks for any help
Don't Quit