Hi,

I am writing xml file from sql server database(Stored Proc) using Xml text writer class ,i

My query is ,If database  datacolumn value has" null" then ,i dont want to show null element in xml file

means i dont need particular end element in xml file

example:

1.<ID>1908</ID>
  <LOCALID>0123456789</LOCALID>
  <Sname>1660</Sname>
  <State>NJ</State>
  <Zip>30824</Zip> 

If State value is null

2.<ID>1908</ID>
  <LOCALID>0123456789</LOCALID>
  <Sname>1660</Sname>
    <Zip>30824</Zip>

I wanted out put like 2 xml file.Please suggest.

Thanks in advance!!!.

Please reply anyone ASAP.