<div>
Hi there.<br />
<br />
Use System.DBNull.Value instead.<br />
<br />
Jas.
</div>


Hi there.

Use System.DBNull.Value instead.

Jas.

<div>
Cool,<br />
<br />
I am getting the following error now on the same line.<br />
<br />
Operator '==' cannot be applied to operands of type 'System.DateTime' and 'System.DBNull'<br />
<br />
Regards,<br />
<br />
Nigel
</div>


Cool,

I am getting the following error now on the same line.

Operator '==' cannot be applied to operands of type 'System.DateTime' and 'System.DBNull'

Regards,

Nigel

<div>
Perfect.<br />
<br />
Thanks for the quick response.<br />
<br />
Regards,<br />
<br />
Nigel
</div>


Perfect.

Thanks for the quick response.

Regards,

Nigel

<div>
Or you could try<br />
<br />
if (Convert.ToDateTime(myValu<wbr />e).Equals(<wbr />System.DBN<wbr />ull.Value)<wbr />
</div>


Or you could try

if (Convert.ToDateTime(myValue).Equals(System.DBNull.Value)

<div>
<div class="content wysiwyg-content">
Hi Guys,<br />
<br />
In ASP.NET c# I need to do an IF to statement to check if a field is null or not. The field is a datetime field. Can anyone see what I am doing wrong? <br />
<br />
&nbsp; if (Convert.ToDateTime(userDa<wbr />ta[&quot;Connec<wbr />tionDateTi<wbr />me&quot;]) == System.DBNull)<br />
<br />
I am am getting the error System.DBNull is a 'type', which is not valid in the given context.<br />
<br />
Hope you can help.<br />
<br />
Regards,<br />
<br />
Nigel
</div>
</div>


Hi Guys,

In ASP.NET c# I need to do an IF to statement to check if a field is null or not. The field is a datetime field. Can anyone see what I am doing wrong? 

  if (Convert.ToDateTime(userData["ConnectionDateTime"]) == System.DBNull)

I am am getting the error System.DBNull is a 'type', which is not valid in the given context.

Hope you can help.

Regards,

Nigel

ASP.NET C# DBNull Check

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

Web applications are systems that run in browsers that perform functions normally associated with other client-based programs. One of the most commonly used web applications is email; instead of downloading individual emails to a local machine, the data is shown through a website. Other examples of web applications are collaborative systems like a wiki or an online game.