SQL syntax in VB.net

SqlConnection sqlConnection1 = new SqlConnection("Driver={MySQL ODBC 5.2 ANSI Driver};server=lServer;user=spalmer;password=mypassword;database=daily_reports");
SqlCommand cmd = new SqlCommand();
SqlDataReader reader;

cmd.CommandText = ""SELECT * FROM 100_report WHERE RPT_DATE > date(now()) - 300"";
cmd.CommandType = CommandType.Text;
cmd.Connection = sqlConnection1;

sqlConnection1.Open();

reader = cmd.ExecuteReader();
// Data is accessible through the DataReader object here.

sqlConnection1.Close();

Select allOpen in new window

Sorry, VB

Dim sqlConnection1 As New SqlConnection("Driver={MySQL ODBC 5.2 ANSI Driver};server=lServer;user=spalmer;password=mypassword;database=daily_reports")
Dim cmd As New SqlCommand
Dim reader As SqlDataReader

cmd.CommandText = "SELECT * FROM 100_report WHERE RPT_DATE > date(now()) - 300"
cmd.CommandType = CommandType.Text
cmd.Connection = sqlConnection1

sqlConnection1.Open()

reader = cmd.ExecuteReader()
' Data is accessible through the DataReader object here.

sqlConnection1.Close()

Select allOpen in new window

Thanks, but I was hoping to use my current code as much as possible.

This code below worked, but the query was too large to so tried to filter with the date to get a smaller result.

rsCodeLookup.Open("SELECT * FROM 100_report", adoConn, CursorTypeEnum.adOpenStatic, LockTypeEnum.adLockReadOnly)

It was only when I added the where clause that I had problems.

Had to rework the DATE_ADD order, but got it to work.  Thanks.