Hi,

Description of problem:

DataSet dsComp= Created dataset by calling stored procedure


In this dsComp, there is one table called tblContract which has 5 columns out of which one column has null value in every row. The stored proc correctly fetches 5 columns from database and dscomp also shows in tblContract 5 columns.


dsComp is loaded into xmldoc

xmlDocComp.LoadXml(dsComp.GetXml());



Reading that xmldoc, a new dataset dsAnk is made.

XmlNodeReader nodeRdrAnk = new XmlNodeReader(xmlNode);

DataSet dsAnk = new DataSet ();

dsAnk.ReadXml(nodeRdrAnk);



dsAnk shows in tblContract only 4 columns, the column with all null values gets negated.

How to retrieve 5 columns in contract table of dsAnk by reading the XMLDoc

Have you tried to load the schema of the first data set first e.g.
Perhaps that helps to preserve the columns.

--
  Martin Honnen
  Microsoft MVP - XML

There's a bad habit on this forum of asking questions that relate to one particular XML technology without saying what technology you are talking about. There was an example last week where we had to guess it was Oracle by recognising the version numbers 9i and 10g. On this one, sorry, I don't recognise it. There are any number of XML libraries containing classes with names like XmlNodeReader. I suspect something to do with .NET, but really I've no idea. If you want answers, you need to explain the problem.

Michael Kay
http://www.saxonica.com/
Author, XSLT Programmer's Reference and XPath 2.0 Programmer's Reference

Regret the inconvenience.

This is related to using XML in asp.net 1.1

Thanks Martin. I am able to retrieve the 5th Column.