ExamGuru IT/.Net Guru : SV: RE: Nulls on ASPFriends.com 'aspngdata' list

.NETGURU

SV: RE: Nulls

Messages

Related Types

This message was discovered on ASPFriends.com 'aspngdata' list.

=?iso-8859-1?Q?Andr=E9_Colbi=F6rnsen?=

How can one check for nulls in a dataset ( it will always be a dataset=20
with=20
one column and one row) and if there is a null then exit sub else carry=20
on=20
with the rest of my code....=20

=20

=20

Any ideas>=20

=20

C=20

=20

-------------------------------------------------------------=20
This email and any files transmitted are=20
confidential and intended solely for the=20
use of the individual or entity to which=20
they are addressed, whose privacy=20
should be respected. Any views or=20
opinions are solely those of the author=20
and do not necessarily represent those=20
of the Trencor Group, or any of its=20
representatives, unless specifically=20
stated. =20

Email transmission cannot be guaranteed=20
to be secure, error free or without virus=20
contamination. The sender therefore=20
accepts no liability for any errors or=20
omissions in the contents of this message,=20
nor for any virus infection that might result=20
from opening this message. Trencor is not=20
responsible in the event of any third party=20
interception of this email. =20

If you have received this email in error please notify=20
Click here to reveal e-mail address For more information about=20
Trencor, visit www.trencor.net <http://www.trencor.net
<http://www.trencor.net> >=20

Reply to this message...

Carlos Magalhaes

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2652.35">
<TITLE>RE: [aspngdata] SV: RE: Nulls</TITLE>
</HEAD>
<BODY>

What I have is a Data set which I fill and then later =
set the value of the dataset to a text box now I need to check for =
nulls first and if it does find a null write "nofun" to the =
control.

Here is what I have so far there will always be one =
column with only one row. Is this correct?


WSIDcmd.Fill(dsWSID, "WorkWSID")
 If =
dsWSID.Tables("WorkWSID").Rows.Item(0).IsNull(0) Then
 &nb=
sp; WSIDTxT.Text =3D "No WS ID "
 =
Else
 &nb=
sp; WSIDTxT.Text =3D =
dsWSID.Tables("WorkWSID").DefaultView(0).Item("WS_NUM&quo=
t;)
 End =
If


-----Original Message-----
 From: Andr=E9 Colbi=F6rnsen [<A =
HREF=3D"mailto:Click here to reveal e-mail address">mailto:Click here to reveal e-mail address</=
A>] 
 Sent: Thursday, May 30, 2002 9:26 PM
 To: aspngdata
 Subject: [aspngdata] SV: RE: Nulls


I haven't really followed this thread Carlos, but =
what seems to be the
 problem?


Regards/Halsningar


Andre Colbiornsen
 --------------------------------------
 Sonnenburg Communications
 Bergsgatan 3,
 SE-211 54 Malm=F6
 Sweden
 Tel.: +46-(0)40-97 78 80
 Fax.: +46-(0)40-97 78 80
 Mob.: +46-(0)708-97 78 79
 Mail: Click here to reveal e-mail address
 Web.: www.sonnenburg.se
 --------------------------------------
 B2B Web agency - Specializing on .Net
 --------------------------------------


-----Ursprungligt meddelande-----
 Fr=E5n: Carlos Magalhaes [<A =
HREF=3D"mailto:Click here to reveal e-mail address">mailto:Click here to reveal e-mail address</A>] =

 Skickat: den 30 maj 2002 21:01
 Till: aspngdata
 =C4mne: [aspngdata] RE: Nulls

 

How can you use this with a dataset .


 


Typecmd.Fill(dstype, "TypeWo")


 


 


?>


-----Original Message-----
 From: Darren Patterson [<A =
HREF=3D"mailto:Click here to reveal e-mail address">mailto:Click here to reveal e-mail address</A>] =

 Sent: Thursday, May 30, 2002 8:55 PM
 To: aspngdata
 Subject: [aspngdata] RE: Nulls


 


I have done this and it seems to handle null values =
from the database
 just fine.


 


Dim lstrTempVar as String


 


If dtrTask("SomeField") Is =
System.DBNull.Value Then


 &nb=
sp; lstrTempVar =3D ""


Else


 &nb=
sp; lstrTempVar =3D dtrTask("SomeField")


End If


 


Use the lstrTempVar for use later in your =
code.


 


-----Original Message-----
 From: Carlos Magalhaes [<A =
HREF=3D"mailto:Click here to reveal e-mail address">mailto:Click here to reveal e-mail address</A>] =

 Sent: Thursday, May 30, 2002 2:18 PM
 To: aspngdata
 Subject: [aspngdata] RE: Nulls


 


Can you explain what this is trying to do ? 


Thanks 


Carlos 


-----Original Message----- 
 From: Jaime Noriega [<A =
HREF=3D"mailto:Click here to reveal e-mail address">mailto:jaime.noriega@entra=
datech.com</A>
 <<A =
HREF=3D"mailto:Click here to reveal e-mail address">mailto:jaime.noriega@entra=
datech.com</A>> ] 
 Sent: Thursday, May 30, 2002 4:35 PM 
 To: aspngdata 
 Subject: [aspngdata] RE: Nulls 


If Not IsDBNull(olRow.Item("required")) =
Then 
 If =
olRow.Item("required") Then 
 =
.BackColor =3D System.Drawing.Color.Aqua 
 End If 
 End If 


 


Jaime Noriega 
 R & D Manager 
 Entrada Technologies LTD 
 <A HREF=3D"http://www.entradatech.com"" target="_blank">http://www.entradatech.com"; =
TARGET=3D"_blank">http://www.entradatech.com</A> <<A =
HREF=3D"http://www.entradatech.com"" target="_blank">http://www.entradatech.com"; =
TARGET=3D"_blank">http://www.entradatech.com</A>> 


 


-----Original Message----- 
 From: Carlos Magalhaes [<A =
HREF=3D"mailto:Click here to reveal e-mail address">mailto:Click here to reveal e-mail address</A></FONT=
>
 <<A =
HREF=3D"mailto:Click here to reveal e-mail address">mailto:Click here to reveal e-mail address</A>> =
] 
 Sent: Thursday, May 30, 2002 10:23 AM 
 To: aspngdata 
 Subject: [aspngdata] Nulls 


-- Moved from [aspngfreeforall] to [aspngdata] by =

 Click here to reveal e-mail address =
<Click here to reveal e-mail address> -- 


This message is in MIME format. Since your mail =
reader does not 
 understand 
 this format, some or all of this message may not be =
legible. 


------_=3D_NextPart_001_01C207E5.80B3AFC0 
 Content-Type: text/plain 


How can one check for nulls in a dataset ( it will =
always be a dataset 
 with 
 one column and one row) and if there is a null then =
exit sub else carry 
 on 
 with the rest of my code.... 


 


 


Any ideas> 


 


C 


 


------------------------------------------------------------- =

 This email and any files transmitted are 
 confidential and intended solely for the 
 use of the individual or entity to which 
 they are addressed, whose privacy 
 should be respected. Any views or 
 opinions are solely those of the author 
 and do not necessarily represent those 
 of the Trencor Group, or any of its 
 representatives, unless specifically 
 stated. 


Email transmission cannot be guaranteed 
 to be secure, error free or without virus 
 contamination. The sender therefore 
 accepts no liability for any errors or 
 omissions in the contents of this message, 
 nor for any virus infection that might result =

 from opening this message. Trencor is not =

 responsible in the event of any third party 
 interception of this email. 


If you have received this email in error please =
notify 
 Click here to reveal e-mail address For more =
information about 
 Trencor, visit www.trencor.net <<A =
HREF=3D"http://www.trencor.net" =
TARGET=3D"_blank">http://www.trencor.net</A>
 <<A HREF=3D"http://www.trencor.net" =
TARGET=3D"_blank">http://www.trencor.net</A>> > 


------_=3D_NextPart_001_01C207E5.80B3AFC0 
 Content-Type: text/html 


<html> 


<head> 
 <META HTTP-EQUIV=3D"Content-Type" =
CONTENT=3D"text/html; charset=3Dus-ascii"> 


 


<meta name=3DGenerator content=3D"Microsoft =
Word 10 (filtered)"> 


<style> 
  
 </style> 


</head> 


<body lang=3DEN-US link=3Dblue vlink=3Dpurple> =



<div class=3DSection1> 



 style=3D'font-size:10.0pt; 
 font-family:Arial'>How can one check for nulls in =
a dataset ( it will 
 always be 
 a dataset with one column and one row) and if there =
is a null then exit 
 sub 
 else carry on with the rest of my =
code.... 



 style=3D'font-size:10.0pt; 
 font-family:Arial'> </=
p> 



 style=3D'font-size:10.0pt; 
 font-family:Arial'> </=
p> 



 style=3D'font-size:10.0pt; 
 font-family:Arial'>Any =
ideas> 



 style=3D'font-size:10.0pt; 
 font-family:Arial'> </=
p> 



 style=3D'font-size:10.0pt; 
 font-family:Arial'>C =



</div> 


| [aspngdata] member Click here to reveal e-mail address =
=3D YOUR ID 
 | <A =
HREF=3D"http://www.asplists.com/asplists/aspngdata.asp" =
TARGET=3D"_blank">http://www.asplists.com/asplists/aspngdata.asp</A></FO=
NT>
 <<A =
HREF=3D"http://www.asplists.com/asplists/aspngdata.asp" =
TARGET=3D"_blank">http://www.asplists.com/asplists/aspngdata.asp</A>>=
=3D JOIN/QUIT 
 | <A HREF=3D"http://www.asplists.com/search" =
TARGET=3D"_blank">http://www.asplists.com/search</A> <<A =
HREF=3D"http://www.asplists.com/search" =
TARGET=3D"_blank">http://www.asplists.com/search</A>> =3D =

 | SEARCH
 Archives 


 


| [aspngdata] member Click here to reveal e-mail address =3D YOUR =
ID 
 | <A =
HREF=3D"http://www.asplists.com/asplists/aspngdata.asp" =
TARGET=3D"_blank">http://www.asplists.com/asplists/aspngdata.asp</A></FO=
NT>
 <<A =
HREF=3D"http://www.asplists.com/asplists/aspngdata.asp" =
TARGET=3D"_blank">http://www.asplists.com/asplists/aspngdata.asp</A>>=
=3D JOIN/QUIT 
 | <A HREF=3D"http://www.asplists.com/search" =
TARGET=3D"_blank">http://www.asplists.com/search</A> <<A =
HREF=3D"http://www.asplists.com/search" =
TARGET=3D"_blank">http://www.asplists.com/search</A>> =3D =

 | SEARCH
 Archives 

 

| [aspngdata] member Click here to reveal e-mail address =3D YOUR =
ID 
 | <A =
HREF=3D"http://www.asplists.com/asplists/aspngdata.asp" =
TARGET=3D"_blank">http://www.asplists.com/asplists/aspngdata.asp</A> =
=3D JOIN/QUIT 
 | <A HREF=3D"http://www.asplists.com/search" =
TARGET=3D"_blank">http://www.asplists.com/search</A> =3D SEARCH =
Archives 


</BODY> 


</html> 


------_=3D_NextPart_001_01C207E5.80B3AFC0-- 


| [aspngdata] member Click here to reveal e-mail address =3D YOUR ID =

 | <A =
HREF=3D"http://www.asplists.com/asplists/aspngdata.asp" =
TARGET=3D"_blank">http://www.asplists.com/asplists/aspngdata.asp</A> =
=3D JOIN/QUIT 
 | <A HREF=3D"http://www.asplists.com/search" =
TARGET=3D"_blank">http://www.asplists.com/search</A> =3D SEARCH =
Archives


------------------------------------------------------------- =
This email
 and any files transmitted are confidential and =
intended solely for the
 use of the individual or entity to which they are =
addressed, whose
 privacy should be respected. Any views or opinions =
are solely those of
 the author and do not necessarily represent those of =
the Trencor Group,
 or any of its representatives, unless specifically =
stated. Email
 transmission cannot be guaranteed to be secure, =
error free or without
 virus contamination. The sender therefore accepts no =
liability for any
 errors or omissions in the contents of this message, =
nor for any virus
 infection that might result from opening this =
message. Trencor is not
 responsible in the event of any third party =
interception of this email.
 If you have received this email in error please =
notify
 Click here to reveal e-mail address For more information about =
Trencor, visit
 www.trencor.net 

 

-------------------------------------------------------------</=
FONT>
 This email and any files transmitted are
 confidential and intended solely for the
 use of the individual or entity to which
 they are addressed, whose privacy
 should be respected. Any views or
 opinions are solely those of the author
 and do not necessarily represent those
 of the Trencor Group, or any of its
 representatives, unless specifically
 stated. 


Email transmission cannot be guaranteed
 to be secure, error free or without virus
 contamination. The sender therefore
 accepts no liability for any errors or
 omissions in the contents of this message,
 nor for any virus infection that might result
 from opening this message. Trencor is =
not
 responsible in the event of any third party
 interception of this email. 


If you have received this email in error please =
notify
 Click here to reveal e-mail address For more =
information about
 Trencor, visit www.trencor.net <<A =
HREF=3D"http://www.trencor.net" =
TARGET=3D"_blank">http://www.trencor.net</A>>

 

</BODY>
</HTML>

-------------------------------------------------------------
This email and any files transmitted are
confidential and intended solely for the
use of the individual or entity to which
they are addressed, whose privacy
should be respected. Any views or
opinions are solely those of the author
and do not necessarily represent those
of the Trencor Group, or any of its
representatives, unless specifically
stated.

Email transmission cannot be guaranteed
to be secure, error free or without virus
contamination. The sender therefore
accepts no liability for any errors or
omissions in the contents of this message,
nor for any virus infection that might result
from opening this message. Trencor is not
responsible in the event of any third party
interception of this email.

If you have received this email in error please notify
Click here to reveal e-mail address For more information about
Trencor, visit www.trencor.net <http://www.trencor.net>

Reply to this message...

	System.DBNull
	System.Drawing.Color

ExamGuru IT Solutions - .Net Guru is owned and operated by ExamGuru, Inc., the man behind .Net Guru. If you're in the market for bespoke software or software consultancy, why not get him and his highly trained team to help? - www.examguru.net/ITCertification

Need Dot Net Interview Questions?
Ask ExamGuru, Inc. for advice and help on Passing .Net Interviews

.Net Projects
Best-of-breed application framework for .NET projects, developed by ExamGuru, Inc. and ExamGuru IT

Free .net Help
Commission ExamGuru, Inc. and his team for your next bespoke software project

FogBUGZ
The only bug tracking system carefully crafted with one goal in mind: helping teams create great software.

Awesome Tools
If you don't know about these, you're missing out... IT Certification Questions
IT Interview Questions
Free Oracle 10g Training
MCSE Boortcamp
Cisco Study Guides
Cheap Study Guides
Exact Questions
Dot Net Interview Questions
Oracle OCP
Cheap Travel
Designer Perfumes - Wholesale Prices
Free Programming Tutorials

	Copyright © ExamGuru, Inc. 2001-2006
	Contact Us - Terms of Use - Privacy Policy - www.dot-net-guru.com - www.examguru.net - www.oraclesource.net - www.itinterviews.net - www.examguru.net/ITCertification