0

hi there,
i am having problem with my codes. im getting this error,
'Name 'reader' is not declared'. please help.

[B]reader = con2.ExecuteReader()[/B]

[B] reader.Read [/B]


Protected Function SiteSpecificAuthenticationMethod(ByVal UserName As String, ByVal Password As String) As Boolean

        Dim log_statement As String = "SELECT * FROM [user] where username='" & UserName & "' and password='" & Password & "'"

        Dim con2 As System.Data.SqlClient.SqlCommand
        Dim con1 As System.Data.SqlClient.SqlConnection

        con1 = New System.Data.SqlClient.SqlConnection(SqlDataSource1.ConnectionString)
        con1.Open()

        con2 = New System.Data.SqlClient.SqlCommand(log_statement, con1)
        [B]reader = con2.ExecuteReader()[/B]

        If[B] reader.Read [/B]Then

            Return True

        Else

            Return False

        End If

    End Function
4
Contributors
4
Replies
5
Views
8 Years
Discussion Span
Last Post by IdanS
0

Hi There

Pls. see the code that uses reader

You can assign data to sql reader

Public Function CheckRequest(ByVal response As String) As Boolean
        Dim reader As SqlDataReader
        Try
            reader = SqlHelper.ExecuteReader(objConnection, "CheckRequest", RequestName)
            If reader.HasRows Then
                reader.Close()
                objConnection.Close()
                Return True
            Else
                reader.Close()
                objConnection.Close()
                Return False
            End If

        Catch ex As Exception

            objConnection.Close()
        End Try

    End Function
0
reader = con2.ExecuteReader()

try this:

Dim reader As SqlDataReader
reader = con2.ExecuteReader()

or:

Dim reader As SqlDataReader = con2.ExecuteReader()
0

they are correct..

Have you solved your problem? if you have so flag this thread as solved!

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.