"Object reference not set to an instance of an object" problem

[prince -=nore=-]

I have a page, where I'm retrieving a file location from a database and
outputting it's contents (HTML) onto a web page.
On the aspx page, I have referred to the code behind it using the line
below. This is where I'm getting the "Object reference not set to an
instance.." error
<% response.writef ile(thelink())% >.

The function that line is referring to is below. The record is being
retrieved from the database according to its querystring.

Function thelink() As Object

Dim tow As String

tow = Request.QuerySt ring("tow")

If tow <> "" Then

viewstate("tow" ) = "@" & tow

CmdIncLink.Para meters.Item("@t ow").Value = tow

Dim tow_reader As SqlDataReader

Try

nsqlconnn.Open( )

tow_reader = CmdIncLink.Exec uteReader

Do While tow_reader.Read

Return tow_reader("inc link")

Loop

nsqlconnn.Close ()

Catch ex As Exception

End Try

End If

End Function
Thanks,
--
----------
'prince

[cmay]

Is the path a relative webpath, or a physical path (i.e. c:\whatever)?

I'm sure you checked this already but are you sure the function is returning
a string, and not failing? If an exception is thrown or the datareader is
empty, it will be returning nothing. Also, any reason to type it as an
Object and not a String?

"prince -=nore=-" wrote:

I have a page, where I'm retrieving a file location from a database and
outputting it's contents (HTML) onto a web page.
On the aspx page, I have referred to the code behind it using the line
below. This is where I'm getting the "Object reference not set to an
instance.." error
<% response.writef ile(thelink())% >.

The function that line is referring to is below. The record is being
retrieved from the database according to its querystring.

Function thelink() As Object

Dim tow As String

tow = Request.QuerySt ring("tow")

If tow <> "" Then

viewstate("tow" ) = "@" & tow

CmdIncLink.Para meters.Item("@t ow").Value = tow

Dim tow_reader As SqlDataReader

Try

nsqlconnn.Open( )

tow_reader = CmdIncLink.Exec uteReader

Do While tow_reader.Read

Return tow_reader("inc link")

Loop

nsqlconnn.Close ()

Catch ex As Exception

End Try

End If

End Function
Thanks,
--
----------
'prince

[prince -=nore=-]

I fixed the problem thanks...

--
----------
'prince
"cmay" <cm**@discussio ns.microsoft.co m> wrote in message
news:67******** *************** ***********@mic rosoft.com...

Is the path a relative webpath, or a physical path (i.e. c:\whatever)?

I'm sure you checked this already but are you sure the function is
returning
a string, and not failing? If an exception is thrown or the datareader is
empty, it will be returning nothing. Also, any reason to type it as an
Object and not a String?

"prince -=nore=-" wrote:

I have a page, where I'm retrieving a file location from a database and
outputting it's contents (HTML) onto a web page.
On the aspx page, I have referred to the code behind it using the line
below. This is where I'm getting the "Object reference not set to an
instance.." error
<% response.writef ile(thelink())% >.

The function that line is referring to is below. The record is being
retrieved from the database according to its querystring.

Function thelink() As Object

Dim tow As String

tow = Request.QuerySt ring("tow")

If tow <> "" Then

viewstate("tow" ) = "@" & tow

CmdIncLink.Para meters.Item("@t ow").Value = tow

Dim tow_reader As SqlDataReader

Try

nsqlconnn.Open( )

tow_reader = CmdIncLink.Exec uteReader

Do While tow_reader.Read

Return tow_reader("inc link")

Loop

nsqlconnn.Close ()

Catch ex As Exception

End Try

End If

End Function
Thanks,
--
----------
'prince