hi all,
when creating xml file from dataset using dataset.writeXML, it excludes the columns which have null values. Is there a way so that it will keep that columns as well.

thanks

are all the values NULL for each row in the column?

I see your problem. Even if you replace it with blanks, you will still only get the end tag of the element. I have found no resolution to the problem. Let me know if you do.

Jim

i haven't found so far. I will post if i find it.
thanks

Try applying this to the dataset.

    Public Sub returnNullsEmpty(ByRef ods As DataSet)
        Dim oTable As DataTable
        Dim oRow As DataRow
        Dim oColumn As DataColumn

        Dim cProcessInfo As String = "getDataReader"
        Try
            For Each oTable In ods.Tables
                For Each oRow In oTable.Rows
                    For Each oColumn In oTable.Columns
                        If IsDBNull(oRow.Item(oColumn.ColumnName)) Then
                            Select Case oColumn.DataType.ToString
                                Case "System.DateTime"
                                    oRow.Item(oColumn.ColumnName) = CDate("01/01/1900")
                                Case "System.Integer"
                                    oRow.Item(oColumn.ColumnName) = 0
                                Case Else
                                    oRow.Item(oColumn.ColumnName) = ""
                            End Select
                        End If
                    Next
                Next
            Next
        Catch ex As Exception
            returnException(mcModuleName, "setDataSet", ex, "", cProcessInfo, mbDebug)
        End Try

    End Sub

Eonic - Suppliers of bespoke web solutions and EonicWeb Content Management.

Hve you guys found any solution yet?

Does it help to use ISNULL in the select statement?

SELECT ISNULL(Column1,'') AS Column1, ISNULL(Column2,'') AS Column2, etc.

???