Hi

I am currently studying the Beginning ASP.NET 1.1 with VB.NET 2003 but getting in a muddle one part of the code in Chapter 11, I am getting an error of BC30311: Value of type 'System.Data.IDataReader' cannot be converted to 'Integer'.

Here is the line in question that this is refering to: -

Function CheckEmailAddress(ByVal emailAddress As String) As Boolean


    Dim connectionString As String = _
        ConfigurationSettings.AppSettings("ConnectionStrin g")
    Dim dbConnection As System.Data.IDbConnection = _
        New System.Data.OleDb.OleDbConnection(connectionString )

    Dim queryString As String = "SELECT COUNT([Newsletter].[EmailAddress])" & _
        "FROM [Newsletter] WHERE ([Newsletter].[EmailAddress] = @EmailAddress)"
    Dim dbCommand As System.Data.IDbCommand = _
        New System.Data.OleDb.OleDbCommand
        dbCommand.CommandText = queryString
        dbCommand.Connection = dbConnection

    Dim dbParam_emailAddress As System.Data.IDataParameter = _
        New System.Data.OleDb.OleDbParameter
        dbParam_emailAddress.ParameterName = "@EmailAddress"
        dbParam_emailAddress.Value = emailAddress
        dbParam_emailAddress.DbType = System.Data.DbType.[String]
        dbCommand.Parameters.Add(dbParam_emailAddress)
    Dim Result As Integer = 0

        dbConnection.Open

        Try
            Result = dbCommand.ExecuteReader
        Finally
            dbConnection.Close
        End Try

        If Result > 0 Then
            Return True
        Else
            Return False
        End If

End Function

The line in red is showing the error. Why is this error being generated?

Thanks

Sharon

hi there.. result is an integer.. maybe you where looking for executescalar that only return a value??? execute reader returns a datareader ;)

HTH

Gonzalo

Ahh, many thanks, not sure why this is in the book I am studying wrong then?

Thanks

Sharon

could be.. if it is a wrox book look for the errata that's is on the main page.. ;)

HTH

Gonzalo