Avatar of Declan Basile
Declan BasileFlag for United States of America

asked on 

Object Reference not set Error

In vb.net, I have a procedure declaration ...

        Private Sub SetSqlDataAdapter(ByRef da As SqlDataAdapter, strTableName As String)

And a call to it ...

        dap1 = New SqlDataAdapter(cmd1)
        Call SetSqlDataAdapter(dap1, "Returns")

dap1 is declared globally in the Form Class  ...

        Dim dap1 As New SqlDataAdapter

Why am I getting the exception "Object reference not set to an instance of an object" on the line that calls the procedure?
Visual Basic.NET

Avatar of undefined
Last Comment
Declan Basile
Avatar of Ryan Chong
Ryan Chong
Flag of Singapore image

Why am I getting the exception "Object reference not set to an instance of an object" on the line that calls the procedure?

have you successfully built/ rebuilt your project?

this worked for me:

Imports System.Data.SqlClient

Public Class Form1
    Dim dap1 As New SqlDataAdapter
    Dim cmd1 As New SqlCommand

    Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load

        dap1 = New SqlDataAdapter(cmd1)
        Call SetSqlDataAdapter(dap1, "Returns")

        MsgBox("Done")
    End Sub

    Private Sub SetSqlDataAdapter(ByRef da As SqlDataAdapter, strTableName As String)
        'do your stuffs here
    End Sub
End Class

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Declan Basile
Declan Basile
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Visual Basic.NET
Visual Basic.NET

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to Visual Basic pre-2002, it is not the same technology,

96K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo