' Adjust a dataset to avoid null values ' expO1 Dataset Public Function AdjustDataSetToAvoidNullValue(ByVal toDataSet As DataSet) As DataSet Dim ldDate As Date = oApp.GetEmptyDate() Dim loColumn As DataColumn Dim loRow As DataRow Dim loTable As DataTable For Each loTable In toDataSet.Tables For Each loRow In loTable.Rows For Each loColumn In loTable.Columns If IsDBNull(loRow.Item(loColumn.ColumnName)) Then Select Case loColumn.DataType.ToString Case "System.DateTime" loRow.Item(loColumn.ColumnName) = ldDate Case "System.Integer" loRow.Item(loColumn.ColumnName) = 0 Case "System.Decimal" loRow.Item(loColumn.ColumnName) = 0 Case "System.Boolean" loRow.Item(loColumn.ColumnName) = False Case Else loRow.Item(loColumn.ColumnName) = "" End Select End If Next Next Next Return toDataSet End FunctionOn a 7000 records dataset, which contains a lot of fields, this process can take up to 4 seconds.