[RESOLVED] Data Reader Null problem

[FishGuy]

Hi,
looking at the code below you can see Im just filling a data table through a data reader. But everytime I try read a value that is null I get a SQLNullValueException this method or action cannot be called on NullValues.

Do While objDatabase.SqlRdrCustomers.Read
                dr = ddsRecommends.tblRecommends.NewRow()
                dr("PK_RecommendID") = objDatabase.SqlRdrCustomers.GetValue(0)
                dr("FK_SaleNo") = objDatabase.SqlRdrCustomers.GetValue(1)
                dr("InsertDate") = objDatabase.SqlRdrCustomers.GetDateTime(2)
                dr("Status") = objDatabase.SqlRdrCustomers.GetValue(3)
                dr("DateOfSale") = objDatabase.SqlRdrCustomers.GetDateTime(4)
  [U]              dr("DateLastLetterSent") = objDatabase.SqlRdrCustomers.GetDateTime(5)[/U]
                dr("LettersSentCount") = objDatabase.SqlRdrCustomers.GetValue(6)
                dr("CustName") = objDatabase.SqlRdrCustomers.GetString(7)
                ddsRecommends.tblRecommends.Rows.Add(dr)
                objMainform.ProgressBar1.PerformStep()
            Loop