Author: jfbomber | Posted on: 6/19/2008 10:20:48 AM | Views : 427

 I know that this has been discussed but I cant seem to find the answer that makes this function work. I have a null value on a few of these columns I want to convert the null value to a string that says "No Value"

 
Public Shared Function GetAllCustomers() As List(Of CustomerDetails)
        Dim cn As New SqlConnection("#####")
        Dim cm As New SqlCommand
        Dim Reader As SqlDataReader
        Dim Customers As New List(Of CustomerDetails)

        With cm
            .CommandType = CommandType.Text
            .CommandText = "SELECT * FROM Customer"
        ...

Go to the complete details ...