Click here to Skip to main content
15,894,539 members
Home / Discussions / Visual Basic
   

Visual Basic

 
GeneralRe: WM_MOUSEMOVE Help Needed Pin
Gideon Engelberth26-Nov-08 7:40
Gideon Engelberth26-Nov-08 7:40 
GeneralRe: WM_MOUSEMOVE Help Needed Pin
Christian Graus26-Nov-08 7:45
protectorChristian Graus26-Nov-08 7:45 
GeneralRe: WM_MOUSEMOVE Help Needed Pin
Luc Pattyn26-Nov-08 8:53
sitebuilderLuc Pattyn26-Nov-08 8:53 
GeneralRe: WM_MOUSEMOVE Help Needed Pin
Christian Graus26-Nov-08 10:02
protectorChristian Graus26-Nov-08 10:02 
GeneralRe: WM_MOUSEMOVE Help Needed Pin
Luc Pattyn26-Nov-08 10:45
sitebuilderLuc Pattyn26-Nov-08 10:45 
GeneralRe: WM_MOUSEMOVE Help Needed Pin
Christian Graus26-Nov-08 13:03
protectorChristian Graus26-Nov-08 13:03 
GeneralRe: WM_MOUSEMOVE Help Needed Pin
EliottA27-Nov-08 2:38
EliottA27-Nov-08 2:38 
QuestionDataTable.Select question re Date columns Pin
TheComputerMan26-Nov-08 4:27
TheComputerMan26-Nov-08 4:27 
Hi, I have tried this every which way but loose (maybe I should have tried that one as well!)

I need to select rows from a datatable based on a date column but no matter how I format the date it just errors.

The sample in MS help does not work either.

Microsoft Example
'Presuming the DataTable has a column named Date.
    Dim expression As String<br />
    expression = "Date > '1/1/00'"<br />
    Dim foundRows() As DataRow<br />
<br />
    ' Use the Select method to find all rows matching the filter.<br />
    foundRows = table.Select(expression)


My Code
dteTStart = Me.m_dteCurrentGraphStart.AddDays(-1)<br />
dteTEnd = Me.m_dteCurrentGraphEnd.AddDays(1)<br />
strFilter = "TradingDate > '" & dteTStart.ToString("MM/dd/yyyy") & "' AND TradingDate < '" & dteTEnd.ToString("MM/dd/yyyy") & "'"<br />
Dim drowData As DataRow() = m_dtblROIData.Select(strFilter)

The error message

Cannot perform '<' operation on System.DateTime and System.String.

Does any one have any idea how to get round this?

Thanks
AnswerRe: DataTable.Select question re Date columns Pin
Mycroft Holmes26-Nov-08 16:24
professionalMycroft Holmes26-Nov-08 16:24 
AnswerRe: DataTable.Select question re Date columns Pin
Nanda_MR26-Nov-08 17:10
Nanda_MR26-Nov-08 17:10 
QuestionASP.NET (Treeview & Menu) Pin
Nanda_MR26-Nov-08 1:05
Nanda_MR26-Nov-08 1:05 
AnswerRe: ASP.NET (Treeview & Menu) Pin
Tom Deketelaere26-Nov-08 2:06
professionalTom Deketelaere26-Nov-08 2:06 
QuestionAccessing Web browser's text Pin
Gagan.2025-Nov-08 23:17
Gagan.2025-Nov-08 23:17 
QuestionRename Extensions in subfolders Pin
Serpent66625-Nov-08 21:58
Serpent66625-Nov-08 21:58 
AnswerRe: Rename Extensions in subfolders Pin
Ben Fair26-Nov-08 3:39
Ben Fair26-Nov-08 3:39 
GeneralRe: Rename Extensions in subfolders Pin
Serpent66626-Nov-08 12:03
Serpent66626-Nov-08 12:03 
QuestionCOPY A DATA TABLE Pin
Pasan14825-Nov-08 20:41
Pasan14825-Nov-08 20:41 
AnswerRe: COPY A DATA TABLE Pin
Christian Graus25-Nov-08 21:01
protectorChristian Graus25-Nov-08 21:01 
AnswerRe: COPY A DATA TABLE Pin
Amit Kushwaha25-Nov-08 22:56
Amit Kushwaha25-Nov-08 22:56 
AnswerRe: COPY A DATA TABLE Pin
Mycroft Holmes26-Nov-08 16:26
professionalMycroft Holmes26-Nov-08 16:26 
Questionopen a website from a windows application in any browser Pin
Sebastian T Xavier25-Nov-08 19:13
Sebastian T Xavier25-Nov-08 19:13 
AnswerRe: open a website from a windows application in any browser Pin
Christian Graus25-Nov-08 19:58
protectorChristian Graus25-Nov-08 19:58 
AnswerRe: open a website from a windows application in any browser Pin
dmex26-Nov-08 6:13
dmex26-Nov-08 6:13 
Questiongurbage values coming from the comport while using mscomm32.ocx Pin
souravghosh1825-Nov-08 18:26
souravghosh1825-Nov-08 18:26 
AnswerRe: gurbage values coming from the comport while using mscomm32.ocx Pin
Nanda_MR25-Nov-08 18:36
Nanda_MR25-Nov-08 18:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.