-----------------------------------------------------------
New Message on MumbaiUserGroup
-----------------------------------------------------------
From: TakeoverAnu
Message 9 in Discussion
New Message on MumbaiUserGroup
Question Of The Day !!!!
Reply
Reply to Sender
Recommend
Message 8 in Discussion
From:
TakeoverAnu
Difference between Null and DBNull :
A null value is a value that doesn't refer to any object. It's the default
value of reference-type variables (e.g., class, interface, delegate).The null
keyword is a literal that represents a null reference with the C# .NET
environment. You may use the null keyword to check or assign the value of an
object.
The use of the DBNull class indicates the absence of a known value. While the
Microsoft documentation says it's typically in a database application, you may
also use it with any type of data. In database applications, a null object is a
valid value for a field. This class differentiates between a null value (a null
object) and an uninitialised value (the DBNull.Value instance). For example, a
table can have records with uninitialised fields. By default, these
uninitialised fields have the DBNull value. You can utilise the DBNull object
by way of its Value property. This represents a null value, which is never
equal to anything.
Substantial difference between them is that if you put a null value in
SqlParameter, though the parameter did not exist, but if you put in
DBNull.Value, the parameter is included with a null value. same like COM
interop thing with VT_NULL and VT_EMPTY
And have you noticed that contrary to the docs, and contrary to SQL as well,
DBNull.Value.Equals(DBNull.Value) is true?
View other groups in this category.
-----------------------------------------------------------
To stop getting this e-mail, or change how often it arrives, go to your E-mail
Settings.
http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw
Need help? If you've forgotten your password, please go to Passport Member
Services.
http://groups.msn.com/_passportredir.msnw?ppmprop=help
For other questions or feedback, go to our Contact Us page.
http://groups.msn.com/contact
If you do not want to receive future e-mail from this MSN group, or if you
received this message by mistake, please click the "Remove" link below. On the
pre-addressed e-mail message that opens, simply click "Send". Your e-mail
address will be deleted from this group's mailing list.
mailto:[EMAIL PROTECTED]
