Hi all
I am having a bit of trouble trying to restrict table data using a date . I am using Microsoft Access, an OleDbConenction and OleDBCommand along with a Datagridview. My code is as follows
any ideas on why I am getting an error?Code:Dim someDate As Date = #5/18/2008# MsgBox(CStr(someDate)) OleDbCommand1.CommandText = "SELECT * FROM AccessLog WHERE Session_Start > '" + someDate + "'" Dim reader As OleDbDataReader = OleDbCommand1.ExecuteReader Dim table As New DataTable table.Load(reader) reader.Close() DataGridView1.DataSource = table DataGridView1.ReadOnly = True




Reply With Quote