dbMe
asked on
Invalid attempt to read when no data is present.
How do I make this code work? I want to get the data from the method but I'm not sure how. I'll up the points by 25 if I can get this figured out within the next hour.
Here's Line 768, which is causing the error below:
Dim amountOwed as Decimal = SelectEventCost(REG_Course List.Selec tedItem.Va lue).Item( "Cost")
And the method that is being used:
Function SelectEventCost(ByVal eventID As Integer) As System.Data.IDataReader
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlC onnection( connection String)
Dim queryString As String = "SELECT [Events].[Cost], [Events].[CoupleCost], [Events].[SiblingCost], [Events].["& _
"FamilyCost], [Events].[MaxCost], [Events].[LateFee] FROM [Events] WHERE ([Events"& _
"].[EventID] = @EventID)"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlC ommand
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dbParam_eventID As System.Data.IDataParameter = New System.Data.SqlClient.SqlP arameter
dbParam_eventID.ParameterN ame = "@EventID"
dbParam_eventID.Value = eventID
dbParam_eventID.DbType = System.Data.DbType.Int32
dbCommand.Parameters.Add(d bParam_eve ntID)
dbConnection.Open
Dim dataReader As System.Data.IDataReader = dbCommand.ExecuteReader(Sy stem.Data. CommandBeh avior.Clos eConnectio n)
Return dataReader
End Function
I get the following error:
System.InvalidOperationExc eption: Invalid attempt to read when no data is present. at System.Data.SqlClient.SqlD ataReader. PrepareRec ord(Int32 i) at System.Data.SqlClient.SqlD ataReader. GetValue(I nt32 i) at System.Data.SqlClient.SqlD ataReader. get_Item(S tring name) at ASP.Default_aspx.REG_btnPa yLater_Cli ck(Object sender, EventArgs e) in C:\Inetpub\wwwroot\Whateve r\Default. aspx:line 768
Thanks!
Here's Line 768, which is causing the error below:
Dim amountOwed as Decimal = SelectEventCost(REG_Course
And the method that is being used:
Function SelectEventCost(ByVal eventID As Integer) As System.Data.IDataReader
Dim dbConnection As System.Data.IDbConnection = New System.Data.SqlClient.SqlC
Dim queryString As String = "SELECT [Events].[Cost], [Events].[CoupleCost], [Events].[SiblingCost], [Events].["& _
"FamilyCost], [Events].[MaxCost], [Events].[LateFee] FROM [Events] WHERE ([Events"& _
"].[EventID] = @EventID)"
Dim dbCommand As System.Data.IDbCommand = New System.Data.SqlClient.SqlC
dbCommand.CommandText = queryString
dbCommand.Connection = dbConnection
Dim dbParam_eventID As System.Data.IDataParameter
dbParam_eventID.ParameterN
dbParam_eventID.Value = eventID
dbParam_eventID.DbType = System.Data.DbType.Int32
dbCommand.Parameters.Add(d
dbConnection.Open
Dim dataReader As System.Data.IDataReader = dbCommand.ExecuteReader(Sy
Return dataReader
End Function
I get the following error:
System.InvalidOperationExc
Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!