XmlDataDocument problem

[david.juffermans]

Hi,

I have a problem reading xml into a dataset using the XmlDataDocument .
In a test project, I created the following xml file:

<?xml version="1.0" standalone="yes "?>
<Customer>
<OrderDetails >
<OrderID>5</OrderID>
<ProductID>6</ProductID>
</OrderDetails>
</Customer>

And I use the following code to read it:

TestDataSet ds = new TestDataSet(); // TestDataSet is a typed dataset
with 1 table "OrderDetai ls", with 1 column "OrderID"
System.Xml.XmlD ataDocument doc = new System.Xml.XmlD ataDocument(ds) ;
doc.Load("Test. xml");

foreach (TestDataSet.Or derDetailsRow row in ds.OrderDetails )
{
Console.WriteLi ne(row.OrderID) ;
}

ds.OrderDetails always has a rowcount of 0.

It works when I change the xml to this:

<?xml version="1.0" standalone="yes "?>
<DataSet xmlns="http://tempuri.org/TestDataSet.xsd ">
<Customer>
<OrderDetails >
<OrderID>5</OrderID>
<ProductID>6</ProductID>
</OrderDetails>
</Customer>
</DataSet>

I used this article to create my test project:
http://msdn2.microsoft.com/en-us/lib...13(VS.80).aspx and I
see no "<DataSet xmlns="http://tempuri.org/TestDataSet.xsd ">" line in
the example xml there

[Maninder Singh]

Hi,

I have a problem reading xml into a dataset using the XmlDataDocument .
In a test project, I created the following xml file:

<?xml version="1.0" standalone="yes "?>
<Customer>
<OrderDetails >
<OrderID>5</OrderID>
<ProductID>6</ProductID>
</OrderDetails>
</Customer>

And I use the following code to read it:

TestDataSet ds = new TestDataSet(); // TestDataSet is a typed dataset
with 1 table "OrderDetai ls", with 1 column "OrderID"
System.Xml.XmlD ataDocument doc = new System.Xml.XmlD ataDocument(ds) ;
doc.Load("Test. xml");

foreach (TestDataSet.Or derDetailsRow row in ds.OrderDetails )
{
Console.WriteLi ne(row.OrderID) ;
}

ds.OrderDetails always has a rowcount of 0.

It works when I change the xml to this:

<?xml version="1.0" standalone="yes "?>
<DataSet xmlns="http://tempuri.org/TestDataSet.xsd ">
<Customer>
<OrderDetails >
<OrderID>5</OrderID>
<ProductID>6</ProductID>
</OrderDetails>
</Customer>
</DataSet>

I used this article to create my test project:
http://msdn2.microsoft.com/en-us/lib...13(VS.80).aspx and I
see no "<DataSet xmlns="http://tempuri.org/TestDataSet.xsd ">" line in
the example xml there

Please give me advice how I write the code for use the string as the input. How to create a function that takes a string and outputs a Dataset. Please if you can give me cods because I am trying but get nothing. Providing you cods below down where I stuck.

Rgards

Maninder Singh
BizTalk Utilities - Frustration free BizTalk Adapters
http://www.topxml.com/biztalkutilities

[maninder singh]

Hi,

I have a problem reading xml into a dataset using the XmlDataDocument .
In a test project, I created the following xml file:

<?xml version="1.0" standalone="yes "?>
<Customer>
<OrderDetails >
<OrderID>5</OrderID>
<ProductID>6</ProductID>
</OrderDetails>
</Customer>

And I use the following code to read it:

TestDataSet ds = new TestDataSet(); // TestDataSet is a typed dataset
with 1 table "OrderDetai ls", with 1 column "OrderID"
System.Xml.XmlD ataDocument doc = new System.Xml.XmlD ataDocument(ds) ;
doc.Load("Test. xml");

foreach (TestDataSet.Or derDetailsRow row in ds.OrderDetails )
{
Console.WriteLi ne(row.OrderID) ;
}

ds.OrderDetails always has a rowcount of 0.

It works when I change the xml to this:

<?xml version="1.0" standalone="yes "?>
<DataSet xmlns="http://tempuri.org/TestDataSet.xsd ">
<Customer>
<OrderDetails >
<OrderID>5</OrderID>
<ProductID>6</ProductID>
</OrderDetails>
</Customer>
</DataSet>

I used this article to create my test project:
http://msdn2.microsoft.com/en-us/lib...13(VS.80).aspx and I
see no "<DataSet xmlns="http://tempuri.org/TestDataSet.xsd ">" line in
the example xml there

Please give me advice how I write the code for use the string as the input. How to create a function that takes a string and outputs a Dataset. Please if you can give me cods because I am trying but get nothing. Providing you cods below down where I stuck.

Rgards

Maninder Singh
BizTalk Utilities - Frustration free BizTalk Adapters
http://www.topxml.com/biztalkutilities

[maninder singh]

Hi,

I have a problem reading xml into a dataset using the XmlDataDocument .
In a test project, I created the following xml file:

<?xml version="1.0" standalone="yes "?>
<Customer>
<OrderDetails >
<OrderID>5</OrderID>
<ProductID>6</ProductID>
</OrderDetails>
</Customer>

And I use the following code to read it:

TestDataSet ds = new TestDataSet(); // TestDataSet is a typed dataset
with 1 table "OrderDetai ls", with 1 column "OrderID"
System.Xml.XmlD ataDocument doc = new System.Xml.XmlD ataDocument(ds) ;
doc.Load("Test. xml");

foreach (TestDataSet.Or derDetailsRow row in ds.OrderDetails )
{
Console.WriteLi ne(row.OrderID) ;
}

ds.OrderDetails always has a rowcount of 0.

It works when I change the xml to this:

<?xml version="1.0" standalone="yes "?>
<DataSet xmlns="http://tempuri.org/TestDataSet.xsd ">
<Customer>
<OrderDetails >
<OrderID>5</OrderID>
<ProductID>6</ProductID>
</OrderDetails>
</Customer>
</DataSet>

I used this article to create my test project:
http://msdn2.microsoft.com/en-us/lib...13(VS.80).aspx and I
see no "<DataSet xmlns="http://tempuri.org/TestDataSet.xsd ">" line in
the example xml there

Dataset ds = CreateFromStrin g(xml);

BizTalk Utilities - Frustration free BizTalk Adapters
http://www.topxml.com/biztalkutilities