G
Guest
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("strConn"))
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
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("strConn"))
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