Reference to non-shared member???

[Tim::..]

Can someone please tell me why I get the following error in my code and how I
fix it!

Error:
Reference to a non-shared member requires an object reference.

I keep getting this error on

objParam1.Value = User.Identity.Name

Thanks

Code..
Public Shared Function GetOfficeName() As String
Dim Myconn As New
SqlConnection(ConfigurationSettings.AppSettings("s trConn"))
Dim cmd As New SqlCommand("UserDetails", Myconn)
cmd.CommandType = CommandType.StoredProcedure

Myconn.Open()

Dim objParam1 As SqlParameter
objParam1 = cmd.Parameters.Add("@UserName", SqlDbType.Char)
objParam1.Direction = ParameterDirection.Input
objParam1.Value = User.Identity.Name

Dim myReader As SqlDataReader = cmd.ExecuteReader()
While myReader.Read()
If User.Identity.Name <> "" Then
Return myReader("offName")
End If
End While
' always call Close when done reading.
myReader.Close()
' Close the connection when done with it.
Myconn.Close()

End Function

[Eliyahu Goldin]

A shared (static) method can't refered a non-shared member which User is.

Either Remove Shared from the function definition, or use
HttpContext.Current.User.

Eliyahu

"Tim::.." <myatix_at_hotmail.com> wrote in message
news:0F**********************************@microsof t.com...

Can someone please tell me why I get the following error in my code and how I fix it!

Error:
Reference to a non-shared member requires an object reference.

I keep getting this error on

objParam1.Value = User.Identity.Name

Thanks

Code..
Public Shared Function GetOfficeName() As String
Dim Myconn As New
SqlConnection(ConfigurationSettings.AppSettings("s trConn"))
Dim cmd As New SqlCommand("UserDetails", Myconn)
cmd.CommandType = CommandType.StoredProcedure

Myconn.Open()

Dim objParam1 As SqlParameter
objParam1 = cmd.Parameters.Add("@UserName", SqlDbType.Char)
objParam1.Direction = ParameterDirection.Input
objParam1.Value = User.Identity.Name

Dim myReader As SqlDataReader = cmd.ExecuteReader()
While myReader.Read()
If User.Identity.Name <> "" Then
Return myReader("offName")
End If
End While
' always call Close when done reading.
myReader.Close()
' Close the connection when done with it.
Myconn.Close()

End Function

[Tim::..]

Thanks...

"Eliyahu Goldin" wrote:

A shared (static) method can't refered a non-shared member which User is.

Either Remove Shared from the function definition, or use
HttpContext.Current.User.

Eliyahu

"Tim::.." <myatix_at_hotmail.com> wrote in message
news:0F**********************************@microsof t.com...

Can someone please tell me why I get the following error in my code and

how I

fix it!

Error:
Reference to a non-shared member requires an object reference.

I keep getting this error on

objParam1.Value = User.Identity.Name

Thanks

Code..
Public Shared Function GetOfficeName() As String
Dim Myconn As New
SqlConnection(ConfigurationSettings.AppSettings("s trConn"))
Dim cmd As New SqlCommand("UserDetails", Myconn)
cmd.CommandType = CommandType.StoredProcedure

Myconn.Open()

Dim objParam1 As SqlParameter
objParam1 = cmd.Parameters.Add("@UserName", SqlDbType.Char)
objParam1.Direction = ParameterDirection.Input
objParam1.Value = User.Identity.Name

Dim myReader As SqlDataReader = cmd.ExecuteReader()
While myReader.Read()
If User.Identity.Name <> "" Then
Return myReader("offName")
End If
End While
' always call Close when done reading.
myReader.Close()
' Close the connection when done with it.
Myconn.Close()

End Function