<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://bhaidar.net/cs/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Difference between NULL and DBNull</title><link>http://bhaidar.net/cs/archive/2006/03/04/128.aspx</link><description>I have always misunderstood the difference between NULL and DBNULL until recently while I was working on ASP.NET web application, and was talking to a Webservice and I found an exception coming from one of the web methods inside the Webservice which is</description><dc:language>en</dc:language><generator>CommunityServer 2.1 SP2 (Build: 61129.1)</generator><item><title>re: Difference between NULL and DBNull</title><link>http://bhaidar.net/cs/archive/2006/03/04/128.aspx#1094</link><pubDate>Sun, 12 Nov 2006 03:11:11 GMT</pubDate><guid isPermaLink="false">f4db8b24-6ab8-4761-abb7-ba7a1cd3b490:1094</guid><dc:creator>eulerbert</dc:creator><description /></item><item><title>re: Difference between NULL and DBNull</title><link>http://bhaidar.net/cs/archive/2006/03/04/128.aspx#2264</link><pubDate>Thu, 25 Jan 2007 07:23:45 GMT</pubDate><guid isPermaLink="false">f4db8b24-6ab8-4761-abb7-ba7a1cd3b490:2264</guid><dc:creator>Paul</dc:creator><description>&lt;p&gt;Excellent, I was facing this exact problem today, couldn't understand why I was getting null from one ExecuteScalar() but DBNull.Value from another.&lt;/p&gt;
&lt;p&gt;Thanks for the explanation!&lt;/p&gt;</description></item><item><title>re: Difference between NULL and DBNull</title><link>http://bhaidar.net/cs/archive/2006/03/04/128.aspx#17615</link><pubDate>Tue, 27 May 2008 04:55:50 GMT</pubDate><guid isPermaLink="false">f4db8b24-6ab8-4761-abb7-ba7a1cd3b490:17615</guid><dc:creator>S.Pushpalatha</dc:creator><description>&lt;p&gt;Its very nice. im also facing problem.thanks for u.&lt;/p&gt;</description></item><item><title>Difference between NULL and DBNull</title><link>http://bhaidar.net/cs/archive/2006/03/04/128.aspx#26390</link><pubDate>Thu, 30 Oct 2008 19:34:51 GMT</pubDate><guid isPermaLink="false">f4db8b24-6ab8-4761-abb7-ba7a1cd3b490:26390</guid><dc:creator>DotNetKicks.com</dc:creator><description>&lt;p&gt;You've been kicked (a good thing) - Trackback from DotNetKicks.com&lt;/p&gt;
</description></item><item><title>What's The Difference Between NULL and DBNull</title><link>http://bhaidar.net/cs/archive/2006/03/04/128.aspx#26401</link><pubDate>Fri, 31 Oct 2008 07:21:40 GMT</pubDate><guid isPermaLink="false">f4db8b24-6ab8-4761-abb7-ba7a1cd3b490:26401</guid><dc:creator>Surinder's Blog</dc:creator><description>&lt;p&gt;What's The Difference Between NULL and DBNull&lt;/p&gt;
</description></item><item><title>re: Difference between NULL and DBNull</title><link>http://bhaidar.net/cs/archive/2006/03/04/128.aspx#27245</link><pubDate>Tue, 02 Dec 2008 06:52:56 GMT</pubDate><guid isPermaLink="false">f4db8b24-6ab8-4761-abb7-ba7a1cd3b490:27245</guid><dc:creator>milind</dc:creator><description>&lt;p&gt;Thanks &amp;nbsp;i m facing same problem &lt;/p&gt;
&lt;p&gt;while insertig null value in &amp;nbsp;smalldatetime&lt;/p&gt;
&lt;p&gt; through procedure &lt;/p&gt;
&lt;p&gt; &amp;nbsp;cmd.Parameters.Add(&amp;quot;@app_date&amp;quot;, &amp;nbsp; &amp;nbsp; &amp;nbsp;SqlDbType.SmallDateTime).Value = DBNull.value;&lt;/p&gt;</description></item><item><title>re: Difference between NULL and DBNull</title><link>http://bhaidar.net/cs/archive/2006/03/04/128.aspx#37729</link><pubDate>Fri, 22 May 2009 17:51:12 GMT</pubDate><guid isPermaLink="false">f4db8b24-6ab8-4761-abb7-ba7a1cd3b490:37729</guid><dc:creator>JohnM</dc:creator><description>&lt;p&gt;Thanks, that was a very useful description. &lt;/p&gt;
&lt;p&gt;Can you help me here: are there any other examples besides ExecuteScalar() where the difference between null and DB.Null matters? &amp;nbsp;E.g. With parameters?&lt;/p&gt;</description></item></channel></rss>