VB.NET SQL Date Range Help

[KA NMC]

I know this is very simple but I cant get the syntax down...
What I'm trying to do is connect to my sql database and pull up a record from a date range that the user puts in...But I just cant get the syntax down...here is my code help will be great.

   Public frmDate As String
    Public toDate As String
 
Private Sub frmWeResults_Load
'My problem is here - 
Dim cmd1 As New SqlCommand("Select * from TABLE where TABLE_DATE in" + frmDate + "to" + toDate +, cnn1)

[Plater]

Try this?

Public frmDate As String
Public toDate As String
 
Private Sub frmWeResults_Load
'My problem is here - 
Dim cmd1 As New SqlCommand("Select * from TABLE where TABLE_DATE >=' " & frmDate & "' AND TABLE_DATE <=' " & toDate &"' ", cnn1)
 

Actually your IN ___ to ___ might work if you change the + to an & since that's what VB.NET uses to concatinate strings.

[KA NMC]

Thanks - that was a friggen pain...its always the simple things that get ya....

Try this?

Public frmDate As String
Public toDate As String
 
Private Sub frmWeResults_Load
'My problem is here - 
Dim cmd1 As New SqlCommand("Select * from TABLE where TABLE_DATE >=' " & frmDate & "' AND TABLE_DATE <=' " & toDate &"' ", cnn1)
 

Actually your IN ___ to ___ might work if you change the + to an & since that's what VB.NET uses to concatinate strings.