Data Export into XML Format in ASP.Net

Question

Dear,

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

Below is the code

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 version="1.0"?>

-<NewDataSet>

<Emp_No>1</Emp_No>

<Emp_Name>A</Emp_Name>

<Emp_GSM1>122</Emp_GSM1>

</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.

Manas Mohapatra · Answer

Hi Basit, Please try to handle NULL value when you are fetching value from DB. See below code: Dim da As New SqlDataAdapter("select Emp_No,Emp_Name, ISNULL(Emp_GSM1, '') from Employee", con); It means if Emp_GSM1 value is NULL then it return blank string. Then when you are exporting to XML it won't create any problem. You can apply ISNULL() for other columns if you are expecting that these column value may be NULL. Secondly please try not to use this XmlDataDocument class as this is going to obsolete. Use dataset to export xml like below code: ds.WriteXml("D:\Employee.xml");

Basit Khan · Answer

Many thanks Dear