InvalidOperationException was unhandled

[lotus18]

Private Data As OleDbDataReader
Private Command As New OleDbCommand
 
Friend Function Conflict(ByVal DayID As String, ByVal Room As String, ByVal _
 NewTimeStarted As Date, ByVal NewTimeFinished As Date, ByVal SectionUnit As String, _
  ByVal Semester As String) As Boolean
        'Dim SectionUnit As String
        'SectionUnit = Course & " " & Section
        'Conflict = False 'Default Value
 
 
        Main.SetConnection() 'Set Database Connection
 
        'PHASE 1 | CHECK ROOM SCHEDULES
        Command = New OleDbCommand("Select * From LoadSchedules Where Rooms.Title='" & Room & _
       "' And Not Rooms.Title='Field' And Semester='" & Semester & "' And DayID='" _
       & DayID & "'", dbConnection)
        Command.CommandType = CommandType.Text
        Data = Command.ExecuteReader
 
        If (Data("TimeStarted") >= NewTimeStarted) And (Data("TimeStarted") < NewTimeFinished) Then
            Conflict = True
            'MsgBox "1 | Conflict sa 1st day. May nakaschedule na sa room na ito."
            ShowConflict(Data("SectionUnit"), _
            Data("Rooms.Title"), Data("DayID"), _
            Data!TimeStarted, Data!TimeFinished)
            Exit Function
        End If
 
        Data.Close()
End Function

The bold text says "No data exists for the row/column" Please help :'(

Rey Sean

[jeffstl]

You need to make sure you reader is actually pulling data.

Sounds like its not which means either your query is not right, or the database doesn't have the data you are expecting it to have.

 
If Data.Read then
     'your data is there
else
     'your data is not there
end if
 
 

[lotus18]

You need to make sure you reader is actually pulling data.

Sounds like its not which means either your query is not right, or the database doesn't have the data you are expecting it to have.

 
If Data.Read then
     'your data is there
else
     'your data is not there
end if
 
 

You are a little bit right. I've change the query

[color=#222222]
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Thanks : )

Rey Sean