''SqlDataReader not define" error

[paapa21]

I want to Declear a variable as SqlDataReader in ASP 2.0. But when i do so it
tells me SqlDataReader is not define. This same code works in my previous
application in ASP 1.0. Has this change? Can someone show me how to do this.
Below is the function and the line of the error is bold.

Function GetUniversity() As String
Dim Unipayment As New UnipaymentDB
Dim CIDR As SqlDataReader =
Unipayment.StudentState(Request.Params("StudentID" ))

'Intilize university name depending on courseID
GetUniversity = ""
If CIDR.Read Then
If CIDR("CourseID") = "CMS" Or CIDR("CouresID") =
"DMS" Or CIDR("CourseID") = "MBA" Then
GetUniversity = "University of Leicester"
Else
GetUniversity = "London Metropolitan
University"
End If
CIDR.close()
End If
End Function

[Karl Seguin [MVP]]

are you referencing and importing System.Data.SqlClient?

Karl

--
http://www.openmymind.net/

"paapa21" <pa*****@discussions.microsoft.com> wrote in message
news:C8**********************************@microsof t.com...

I want to Declear a variable as SqlDataReader in ASP 2.0. But when i do so
it
tells me SqlDataReader is not define. This same code works in my previous
application in ASP 1.0. Has this change? Can someone show me how to do
this.
Below is the function and the line of the error is bold.

Function GetUniversity() As String
Dim Unipayment As New UnipaymentDB
Dim CIDR As SqlDataReader =
Unipayment.StudentState(Request.Params("StudentID" ))

'Intilize university name depending on courseID
GetUniversity = ""
If CIDR.Read Then
If CIDR("CourseID") = "CMS" Or CIDR("CouresID") =
"DMS" Or CIDR("CourseID") = "MBA" Then
GetUniversity = "University of Leicester"
Else
GetUniversity = "London Metropolitan
University"
End If
CIDR.close()
End If
End Function

[paapa21]

yes i'm referencing it and i do have system.data.sqlclient in the page-behind
code in the app_code folder where unipaymentdb is still not work.

i tried Dim CIDR As System.Data.SqlClient.SqlDataReader =
Unipayment.StudentState(Request.Params("StudentID" )) which worked. But don't
know why the previous doen't
"Karl Seguin [MVP]" wrote:

are you referencing and importing System.Data.SqlClient?

Karl

--
http://www.openmymind.net/

"paapa21" <pa*****@discussions.microsoft.com> wrote in message
news:C8**********************************@microsof t.com...

I want to Declear a variable as SqlDataReader in ASP 2.0. But when i do so
it
tells me SqlDataReader is not define. This same code works in my previous
application in ASP 1.0. Has this change? Can someone show me how to do
this.
Below is the function and the line of the error is bold.

Function GetUniversity() As String
Dim Unipayment As New UnipaymentDB
Dim CIDR As SqlDataReader =
Unipayment.StudentState(Request.Params("StudentID" ))

'Intilize university name depending on courseID
GetUniversity = ""
If CIDR.Read Then
If CIDR("CourseID") = "CMS" Or CIDR("CouresID") =
"DMS" Or CIDR("CourseID") = "MBA" Then
GetUniversity = "University of Leicester"
Else
GetUniversity = "London Metropolitan
University"
End If
CIDR.close()
End If
End Function

[Karl Seguin [MVP]]

well, atleast you got it working. I'm not sure what the issue is either. I'd
still guess it's just a syntax error somewhere..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"paapa21" <pa*****@discussions.microsoft.com> wrote in message
news:7B**********************************@microsof t.com...

yes i'm referencing it and i do have system.data.sqlclient in the
page-behind
code in the app_code folder where unipaymentdb is still not work.

i tried Dim CIDR As System.Data.SqlClient.SqlDataReader =
Unipayment.StudentState(Request.Params("StudentID" )) which worked. But
don't
know why the previous doen't
"Karl Seguin [MVP]" wrote:

are you referencing and importing System.Data.SqlClient?

Karl

--
http://www.openmymind.net/

"paapa21" <pa*****@discussions.microsoft.com> wrote in message
news:C8**********************************@microsof t.com...

>I want to Declear a variable as SqlDataReader in ASP 2.0. But when i do
>so
>it
> tells me SqlDataReader is not define. This same code works in my
> previous
> application in ASP 1.0. Has this change? Can someone show me how to do
> this.
> Below is the function and the line of the error is bold.
>
> Function GetUniversity() As String
> Dim Unipayment As New UnipaymentDB
> Dim CIDR As SqlDataReader =
> Unipayment.StudentState(Request.Params("StudentID" ))
>
> 'Intilize university name depending on courseID
> GetUniversity = ""
> If CIDR.Read Then
> If CIDR("CourseID") = "CMS" Or CIDR("CouresID")
> =
> "DMS" Or CIDR("CourseID") = "MBA" Then
> GetUniversity = "University of Leicester"
> Else
> GetUniversity = "London Metropolitan
> University"
> End If
> CIDR.close()
> End If
> End Function
>

[paapa21]

Thank Karl. I review the code to check for syntax error.

"Karl Seguin [MVP]" wrote:

well, atleast you got it working. I'm not sure what the issue is either. I'd
still guess it's just a syntax error somewhere..

Karl

--
MY ASP.Net tutorials
http://www.openmymind.net/
"paapa21" <pa*****@discussions.microsoft.com> wrote in message
news:7B**********************************@microsof t.com...

yes i'm referencing it and i do have system.data.sqlclient in the
page-behind
code in the app_code folder where unipaymentdb is still not work.

i tried Dim CIDR As System.Data.SqlClient.SqlDataReader =
Unipayment.StudentState(Request.Params("StudentID" )) which worked. But
don't
know why the previous doen't
"Karl Seguin [MVP]" wrote:

are you referencing and importing System.Data.SqlClient?

Karl

--
http://www.openmymind.net/

"paapa21" <pa*****@discussions.microsoft.com> wrote in message
news:C8**********************************@microsof t.com...
>I want to Declear a variable as SqlDataReader in ASP 2.0. But when i do
>so
>it
> tells me SqlDataReader is not define. This same code works in my
> previous
> application in ASP 1.0. Has this change? Can someone show me how to do
> this.
> Below is the function and the line of the error is bold.
>
> Function GetUniversity() As String
> Dim Unipayment As New UnipaymentDB
> Dim CIDR As SqlDataReader =
> Unipayment.StudentState(Request.Params("StudentID" ))
>
> 'Intilize university name depending on courseID
> GetUniversity = ""
> If CIDR.Read Then
> If CIDR("CourseID") = "CMS" Or CIDR("CouresID")
> =
> "DMS" Or CIDR("CourseID") = "MBA" Then
> GetUniversity = "University of Leicester"
> Else
> GetUniversity = "London Metropolitan
> University"
> End If
> CIDR.close()
> End If
> End Function
>