Good Afternoon All, I have built everything for Beta one and I thought I had done very well until and Exception happens when I try and run it. Please could someone take a look at this and see if you know whats causing it:
Message: {"No value given for one or more required parameters."}
Error Code: -2147217904
Item: In order to evaluate an indexed property, the property must be qualified and the arguments must be explicitly supplied by the user.
I don't know whether more info is required from the error but it happens on this line:
DReader = DSelectCommand.ExecuteReader
Here is the full code:
I have checked the database is in the target location and the table names and column names are all correct.HTML Code:Dim DoleDBConn As New OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Application.StartupPath & "\DBtord.mdb;User Id=admin;Password=;") Dim DSelectCommand As New OleDb.OleDbCommand("SELECT Record,TimeLimit,Displays,NamePlayer FROM Dares WHERE Category IN " & SelectedPacks, DoleDBConn) DoleDBConn.Open() Dim DReader As OleDb.OleDbDataReader DReader = DSelectCommand.ExecuteReader DareDT.Load(DReader) DReader.Close() DoleDBConn.Close()





Reply With Quote