Column contains NULL data

[DaveF]

dr.GetString(2) is Null how do I deal with that?

Line 72: Do While dr.Read
Line 73: aString = aString + CStr(dr.GetValue(0)) + ":" &
dr.GetString(1) + ":" & dr.GetString(2) + ":" + dr.GetString(3) + ":"
Line 74: Loop

--
David

[Curt_C [MVP]]

if(dr.GetValue(0) != null)
....
else
.....
--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"DaveF" <df*****@geodecisions.com> wrote in message
news:%2******************@TK2MSFTNGP12.phx.gbl...

dr.GetString(2) is Null how do I deal with that?

Line 72: Do While dr.Read
Line 73: aString = aString + CStr(dr.GetValue(0)) + ":" &
dr.GetString(1) + ":" & dr.GetString(2) + ":" + dr.GetString(3) + ":"
Line 74: Loop

--
David

[S. Justin Gengo]

Dave,

If Not dr.GetString(2) Is System.DBNull.Value Then

End If

--
Sincerely,

S. Justin Gengo, MCP
Web Developer / Programmer

www.aboutfortunate.com

"Out of chaos comes order."
Nietzsche
"DaveF" <df*****@geodecisions.com> wrote in message
news:%2******************@TK2MSFTNGP12.phx.gbl...

dr.GetString(2) is Null how do I deal with that?

Line 72: Do While dr.Read
Line 73: aString = aString + CStr(dr.GetValue(0)) + ":" &
dr.GetString(1) + ":" & dr.GetString(2) + ":" + dr.GetString(3) + ":"
Line 74: Loop

--
David

[Craig Deelsnyder]

On Mon, 14 Jun 2004 15:25:48 -0400, DaveF <df*****@geodecisions.com> wrote:

dr.GetString(2) is Null how do I deal with that?

Line 72: Do While dr.Read
Line 73: aString = aString + CStr(dr.GetValue(0)) + ":" &
dr.GetString(1) + ":" & dr.GetString(2) + ":" + dr.GetString(3) + ":"
Line 74: Loop

You have to manually check the case that it is DbNull.Value. I usually
create a StringUtil class w/ static methods that do stuff like this ()

Public Static Function StringUtil.ToString(val as object) as string
if ((val = DbNull.value) orelse (val = null)) Then
return String.empty
else
return val.ToString()
end if
end function

sorry, haven't done vb.net in awhile, so use as a guideline...

--
Craig Deelsnyder
Microsoft MVP - ASP/ASP.NET

[LOSER]

Or you could just do a ToString on it....Intellisense won't work but
it will convert DBnull values to "".

On Mon, 14 Jun 2004 15:04:26 -0500, "Craig Deelsnyder"
<cdeelsny@no_spam_4_meyahoo.com> wrote:

On Mon, 14 Jun 2004 15:25:48 -0400, DaveF <df*****@geodecisions.com> wrote:

dr.GetString(2) is Null how do I deal with that?

Line 72: Do While dr.Read
Line 73: aString = aString + CStr(dr.GetValue(0)) + ":" &
dr.GetString(1) + ":" & dr.GetString(2) + ":" + dr.GetString(3) + ":"
Line 74: Loop

You have to manually check the case that it is DbNull.Value. I usually
create a StringUtil class w/ static methods that do stuff like this ()

Public Static Function StringUtil.ToString(val as object) as string
if ((val = DbNull.value) orelse (val = null)) Then
return String.empty
else
return val.ToString()
end if
end function

sorry, haven't done vb.net in awhile, so use as a guideline...