Click here to Skip to main content
15,038,345 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Dear,

I export Data from ASP.Net/SQL to xml successfully.

Below is the code

C#
Dim ds As New DataSet()
        Try
            Dim con As New SqlConnection("server=BAK;initial catalog=Test;uid=sa;pwd=sa")
            con.Open()
            Dim da As New SqlDataAdapter("select Emp_No,Emp_Name,Emp_GSM1 from Employee", con)
            da.Fill(ds, "Employee")
        Catch
            'Label1.Text = "Error while connecting to a database"
        End Try
        Dim doc As New XmlDataDocument(ds)
        Xml1.Document = doc
        doc.Save("D:\Employee.xml")


But what i'm facing the problem, when Emp_GSM1 is null value then its not showing in XML file.

Example:.

XML
<?xml version="1.0"?>

-<NewDataSet>
<Employee>
<Emp_No>1</Emp_No>
<Emp_Name>A</Emp_Name>
<Emp_GSM1>122</Emp_GSM1>
</Employee>

<Employee>
<Emp_No>2</Emp_No>
<Emp_Name>B</Emp_Name>  ''here not exporting becoz Emp_GSM1

</Employee>
</NewDataSet>


How to export xml with even null value.

Thanks
Basit.
Posted
Updated 20-Dec-15 0:16am
v2

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900