[RESOLVED] Problems with the DataGridView!!!

[gautamshaw]

I want to fetch some data from the database to the DataGridView,so i did this code:

Dim connString As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Etech.mdb"
        Dim myConnection As OleDbConnection = New OleDbConnection
        myConnection.ConnectionString = connString
        Dim da As OleDbDataAdapter = New OleDbDataAdapter("Select LAcNo,IssuerName,Creditor,Amount,ROI,EMIAmount,BankAcNo,CreditCardNo,Notes from MLoan", myConnection)
        Dim ds As DataSet = New DataSet
        DataGridView1.Columns(0).DataPropertyName = "LAcNo"
        DataGridView1.Columns(1).DataPropertyName = "IssuerName"
        DataGridView1.Columns(2).DataPropertyName = "Creditor"
        DataGridView1.Columns(3).DataPropertyName = "Amount"
        DataGridView1.Columns(4).DataPropertyName = "ROI"
        DataGridView1.Columns(5).DataPropertyName = "EMIAmount"
        DataGridView1.Columns(6).DataPropertyName = "BankAcNo"
        DataGridView1.Columns(7).DataPropertyName = "CreditCardNo"
        DataGridView1.Columns(8).DataPropertyName = "Notes"
        da.Fill(ds, "MLoan")
        Dim dt As New DataTable
        da.Fill(dt)
        DataGridView1.DataSource = dt

Now in the select statement i want to apply a condition that select only those rows from the database where ReminderDate=TodayDate

The date format in my access database is like this:
Attachment 73017
but i cant build up the select statement.....the select statement that i gave above,what will be the where portion then?
ReminderDate=Today.Date will wont work i wish;then what will be the where portion in my select query?