Hi,

Code:

 
QueryStr = @"select * from table1 where Column1={0}";
          QueryStr = String.Format(QueryStr, "1");

          DataSet ds = new DataSet();
          ds = objCon.ExecuteSQL(QueryStr, "Table1");
          String XmlStr = ds.GetXml();

The returning XmlStr Contains

<NewDataSet>
<Table1>
<Column1>1</Column1>
<Column2>Jomet</Column2>
<Column4>2008-12-24T10:52:49.197+05:30</Column4>
</Table1>
</NewDataSet>

Node Column3 is missing
In Table1 Column3 contains NULL value.

TIA

There's one way of handling this here: http://devlicio.us/blogs/derik_whitt...ll-values.aspx
It depends on why you need the null column to be shown.

__________________
Joe
http://joe.fawcett.name/

Thanks for your answer.

I checked the link. but it is writing to a file.

I want it to be in string, so that i can concatenate several tables and make an xml output which is used as an input for testing another tool.

i solved it by using ISNULL function in query.

if any other methods please let me know?
thanks