In SQL is have a column with data and Null values. The Null values need to be converted to string. Thus far nothing I have tried works.
The results are sent to a datagrid.
My code snipet:
DataAccessLayer:
While reader.Read()
   colEmployees.Add((New Staff( _
   (reader("Cars"))
End While

BusinessLayer:
        Public Property Cars() As String
            Get
                Return m_Car
            End Get
            Set(ByVal value As String)
                value = System.Convert.ToString("m_Car")
            End Set
        End Property

Hi there,

Take a look at the IsDBNull method of the data readers: http://msdn2.microsoft.com/en-US/lib....isdbnull.aspx

It allows you to check whether a column is null *before* you assign it to the string. Then you got the chance to assign something different to the string instead.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Author of ASP.NET 2.0 Instant Results and Beginning Dreamweaver MX / MX 2004
Want to be my colleague? Then check out this post.