Selecting a date

[cpopham]

I have changed my data typeto text in my Access database, but I am still not getting any results. This is my code:

 

Private Sub Calendar1_SelectionChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles Calendar1.SelectionChanged

Dim strSelected As String = Calendar1.SelectedDate.Date.ToShortDateString

Dim STRs As Date = CDate(strSelected)

myDA = New OleDbDataAdapter("SELECT * " & _

"FROM EventsTable " & _

"WHERE EventDate= '" & strSelected & "'", myConnection)

 

dsSelDate = New DataSet

myDA.Fill(dsSelDate)

If dsSelDate.Tables(0).Rows.Count = 0 Then

DataGrid1.Visible = False

Else

DataGrid1.Visible = True

DataGrid1.DataSource = dsSelDate

DataGrid1.DataBind()

End If

End Sub

 

I am choosing a date that has information and when I run the query in my database with the selected date, it works fine, but I can not get it to work in code.

 

Any ideas?

 

Chester

[Nerseus]

I believe you must use the number/pound sign to surround a Date in Access:

SELECT * FROM Table1 WHERE DateColumn = #12/31/1999#

 

In SQL Server you use single quotes:

SELECT * FROM Table1 WHERE DateColumn = '12/31/1999'

 

There's probably also some preferred format that Access will want - maybe "month/day/year" vs "year/month/day" etc.

 

-ner

[cpopham]

I got it to work. I put my SQL statement in a string variable and it works fine now :)

 

My only problem would be if I was working with a database that I could not change the data type to string and it stayed as a date.

 

Chester

[pelikan]

whoa! weak is bad.