problem with null data in sql

[luna]

could someone explain the meaning behind :- System.IndexOutOfRangeException:
firstname1

when the code is :-

If objDR("firstname1") Is System.DBNull.Value Then
firstname1.Text = ""
Else : firstname1.Text = objDR("fname1")
End If
and theres no entry in the database if theres an entry in the database there
isnt a problem

[Janaka]

luna,

I take it objDR is a DataReader? Try using its method of
objDR.IsDBNull() - you'll have to use the ordinal number of "firstname1"
instead.
So your code will look more like:

If objDR.IsDBNull(0) Then
....
End If

"luna" <lu**@themoon.com> wrote in message
news:Ap***************@newsfep3-gui.server.ntli.net...

could someone explain the meaning behind :- System.IndexOutOfRangeException: firstname1

when the code is :-

If objDR("firstname1") Is System.DBNull.Value Then
firstname1.Text = ""
Else : firstname1.Text = objDR("fname1")
End If
and theres no entry in the database if theres an entry in the database there isnt a problem

[Dan Brussee]

Your comment that there is no entry in the database makes me think
that the objDR is empty, so there is no current record. This is very
different than a field having a null value. Check if objDR is nothing
(or null depending on language flavor) before testing. You should
probably handle a null record differently than a null field value.

On Wed, 28 Jan 2004 11:54:51 -0000, "luna" <lu**@themoon.com> wrote:

could someone explain the meaning behind :- System.IndexOutOfRangeException:
firstname1

when the code is :-

If objDR("firstname1") Is System.DBNull.Value Then
firstname1.Text = ""
Else : firstname1.Text = objDR("fname1")
End If
and theres no entry in the database if theres an entry in the database there
isnt a problem

[luna]

that did the trick thanks!!

mark
"Janaka" <ja****@magicalia.com> wrote in message
news:Oc**************@TK2MSFTNGP11.phx.gbl...

luna,

I take it objDR is a DataReader? Try using its method of
objDR.IsDBNull() - you'll have to use the ordinal number of "firstname1"
instead.
So your code will look more like:

If objDR.IsDBNull(0) Then
...
End If

"luna" <lu**@themoon.com> wrote in message
news:Ap***************@newsfep3-gui.server.ntli.net...

could someone explain the meaning behind :-

System.IndexOutOfRangeException:

firstname1

when the code is :-

If objDR("firstname1") Is System.DBNull.Value Then
firstname1.Text = ""
Else : firstname1.Text = objDR("fname1")
End If
and theres no entry in the database if theres an entry in the database

there

isnt a problem

[luna]

yes no entry in the database

If objDR.IsDBNull(1) Then
seems to do the trick

thanks

mark

"Dan Brussee" <db******@nc.rr.com> wrote in message
news:om********************************@4ax.com...

Your comment that there is no entry in the database makes me think
that the objDR is empty, so there is no current record. This is very
different than a field having a null value. Check if objDR is nothing
(or null depending on language flavor) before testing. You should
probably handle a null record differently than a null field value.

On Wed, 28 Jan 2004 11:54:51 -0000, "luna" <lu**@themoon.com> wrote:

could someone explain the meaning behind :- System.IndexOutOfRangeException:firstname1

when the code is :-

If objDR("firstname1") Is System.DBNull.Value Then
firstname1.Text = ""
Else : firstname1.Text = objDR("fname1")
End If
and theres no entry in the database if theres an entry in the database thereisnt a problem