I am trying to retrieve data for a particulare date from sql server 2000 using vb.net 2002 windows form it gives me error my code is:

        con.Close()
        con.Open()
        Dim se As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("Select FollowUpDate,Details from note where FollowUpDate = " & Today, con)
        Dim d As New Data.DataSet()
        se.Fill(d)
        remigrid.DataSource = d.Tables(0)
        con.Close()

can any body help me to solve this

Thanks in Advance

Hi:
the right code should as following:

con.Open()
        Dim se As OleDb.OleDbDataAdapter = New OleDb.OleDbDataAdapter("Select FollowUpDate,Details from note where FollowUpDate = '" & format(Today,"d") & "'", con)
        Dim d As New Data.DataSet()
        se.Fill(d)
        remigrid.DataSource = d.Tables(0)
        con.Close()

first of all,you have to promise the oledb.oledbconnection object was closed,otherwise you should receive as error message.
any other problem you can email to me,my email is:[email protected]

good luck!