NullReference Exception error - Object Reference not set to an instance of an object

Question

5.00/5 (1 vote)

See more:

hi there,

Can anyone help me out with this code I need a solution asap. I keep getting Object reference not set error when i compile it

txt1.Text = ds.Tables("Email").Rows(0).Item("Subject")

is where it seems to error! here is my code:

VB

Partial Public Class MaintainWEDAutoEmail
    Inherits System.Web.UI.Page

    Dim csccode As New CommonCode

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        If User.Identity.IsAuthenticated Then
            If Session("Full_User_Name") = "" Then
                Session("User_Name") = User.Identity.Name
                Session("Full_User_Name") = csccode.FindUserFullName(Session("User_Name"))
            End If
            If Not Page.IsPostBack Then
                If User.IsInRole("maintain-wed-email-update") Or User.IsInRole("superuser") Then
                    btnMaintainUpdate.Visible = True
                Else
                    btnMaintainUpdate.Visible = False
                End If
                Dim ds As DataSet = New DataSet
                ds = csccode.GetWEDAutoEmail
                txt1.Text = ds.Tables("Email").Rows(0).Item("Subject")
                txt2.Text = ds.Tables("Email").Rows(0).Item("Body")
                txt3.Text = ds.Tables("Email").Rows(0).Item("Contact")
            End If
        Else
            Response.Redirect("Login.aspx")
        End If
    End Sub

    Protected Sub btnMaintainUpdate_Click(ByVal sender As Object, ByVal e As EventArgs) Handles btnMaintainUpdate.Click
        lblError.Text = ""
        Try
            lblError.Text = csccode.WEDAutoEmailUpdate(txt1.Text, txt2.Text, txt3.Text)
            If lblError.Text = "" Then
                lblError.Text = "WED Auto Email updated succesfully"
                csccode.Log(Session("Full_User_Name"), "WED Auto Email Update", "Email Update")
            Else
                lblError.Text = "** Problem updating WED Auto Email " & lblError.Text & " **"
            End If
        Catch ex As Exception
            lblError.Text = "** Problem updating WED Auto Email" & ex.Message & " **"
        End Try
    End Sub

End Class

Thanks in advance!

Posted 9-May-12 5:24am

Geofferz

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kschuler · Accepted Answer · 2012-05-09T05:31:00

Your code:

VB

ds = csccode.GetWEDAutoEmail
txt1.Text = ds.Tables("Email").Rows(0).Item("Subject")

The error means that something isn't there. The problem is likely one of these scenarios:
1. The GetWEDAutoEmail returned a dataset that was nothing
2. The dataset does not have a table named "Email"
3. The table "Email" does not have any rows
4. The table "Email" does not have a column named "Subject"

You will have to debug in order to figure out which. Place a break point on the line setting the text in txt1. When the breakpoint is hit, use quickwatch to narrow down which part is missing. You will either need to fix the GetWEAutoEmail or you will need to do checks before setting txt1.

*** UPDATE ***

How to use QuickWatch...well, google[^] has some articles on the topic...but glancing at them they don't have many nice screenshots. But maybe you'll want to look at them anyway. Basically when you've got your programming running and stopped at a breakpoint, you can highlight variables and see what their values are. So highlight just the ds in your line of code. At this point, you can probably see a popup that shows you more information and data that you've highlighted. You can use that popup, or you can right click and select QuickWatch from the menu. This pops up a menu where you can type in variables and bits of code and see what their values are. Since you had ds highlighted, ds should appear as the Expression that you are evaluating. If it has a value, you'll be able to see all of it's properties and thier values in the grid on the QuickWatch screen. If you can see that the ds has a value, then type in ds.Tables("Email") in the Expression textbox and press enter. Now you are checking to see if THAT has a value. Then type in ds.Tables("Email").Rows(0) to check for a value. Then tack on the .Item("Subject") and check that. It's kind of hard to explain, so you'll have to play with it a little bit to really get the hang of it. Hope this helps.