DBNull if statement

by

This should work. 

if (rsData["usr.ursrdaystime"] != System.DBNull.Value))
{
    strLevel = rsData["usr.ursrdaystime"].ToString();
}

also need to add using statement, like bellow:

using (var objConn = new SqlConnection(strConnection))
     {
        objConn.Open();
        using (var objCmd = new SqlCommand(strSQL, objConn))
        {
           using (var rsData = objCmd.ExecuteReader())
           {
              while (rsData.Read())
              {
                 if (rsData["usr.ursrdaystime"] != System.DBNull.Value)
                 {
                    strLevel = rsData["usr.ursrdaystime"].ToString();
                 }
              }
           }
        }
     }

this’ll automaticly dispose (close) resources outside of block { .. }.

More Related Contents:

  1. What is the difference between null and System.DBNull.Value?
  2. Assign null to a SqlParameter
  3. Handle DBNull in C#
  4. Why is this code invalid in C#?
  5. Simple Text editor – Need to save as Binary format [closed]
  6. How to ignore a property in class if null, using json.net
  7. Why Would I Ever Need to Use C# Nested Classes [duplicate]
  8. Is it abusive to use IDisposable and “using” as a means for getting “scoped behavior” for exception safety?
  9. What strategies and tools are useful for finding memory leaks in .NET?
  10. SQL Query slow in .NET application but instantaneous in SQL Server Management Studio
  11. Why C# doesn’t implement indexed properties?
  12. Console.Read not returning my int32 [duplicate]
  13. Entity Framework/SQL2008 – How to Automatically Update LastModified fields for Entities?
  14. linq where list contains any in list
  15. C# How to loop user input until the datatype of the input is correct?
  16. Creating PowerPoint presentations programmatically
  17. Windows.Forms.Panel 32767 size limit
  18. Initialization Order of Static Fields in Static Class
  19. Setting the default value of a DateTime Property to DateTime.Now inside the System.ComponentModel Default Value Attrbute
  20. How do I list all loaded assemblies?
  21. What is the meaning of “this” in C#
  22. DataGridView with Button Control – Delete Row
  23. listen for a key when the application is not focused
  24. How do attribute classes work?
  25. Issues Doing a String Comparison in LINQ
  26. Unable to find the requested .Net Framework Data Provider. It may not be installed
  27. Bind Dictionary with list in viewmodel to checkboxes
  28. Linq OrderBy against specific values
  29. Serializing/Deserializing Dictionary of objects with JSON.NET
  30. Winforms: SuspendLayout/ResumeLayout is not enough?

Leave a Comment