Object reference not set to an instance of an object.

[shantha05]

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

This is the error i am getting when tried to use following code in my asp.net application

Dim oEmployees As New CMSSol.Employees

oEmployees.LoadByPrimaryKey(1)

Response.Write(oEmployees.LastName)

I have a record in the table for EmployeeId=1

Any Suggestions?????

[mgnoonan]

Yes, try this code instead which should give you more information:

Code: Select all

   Dim oEmployees As New CMSSol.Employees

   If oEmployees.LoadByPrimaryKey(1) Then
      Response.Write(oEmployees.LastName)
   Else
      Response.Write(oEmployees.ErrorMessage)
   End If


If ErrorMessage is blank, then no rows were loaded and no errors occurred.

[shantha05]

I get the following error message

Login failed for user 'WLCDO55510\\ASPNET'

How to proceed further????

[shantha05]

I have solved the problem

I have created the login in MSDE and gave read permissions and it solved the problem

Thanks a lot.

[mgnoonan]

Glad you got it resolved.