How to convert XML data from a webservice to DataTable

Question

1.00/5 (1 vote)

See more:

I created a WCF service to publish a DataTable. The data can be viewed in http://localhost:1234/Service1.svc/TableName in XML format. In my application, I use the code below:

C#

string url = "http://localhost:48677/Service1.svc/GetDataTable";
var webClient = new System.Net.WebClient();
string data = webClient.DownloadString(url);

How can the string data be converted into a DataTable? Thanks.

Posted 5-Sep-13 3:27am

shaning

Add a Solution

Comments

[no name] 5-Sep-13 9:33am

What? You are calling a service method that returns a DataTable and you are trying to get that datatable as a string and then convert it back to a datatable? Why?

shaning 5-Sep-13 9:50am

To ThePhantomUpvoter:
Thanks for your post. I am new in WCF application. My project scenario is below:
1) Create a WCF project that posts a table data (from a Database).
2) In an application project, I can retrieve the data in 1) and then convert it into a DataTable again.
3) Modify the DataTable in 2) and then save it as new Table into the Oracle DB.
I have done 1) and 3), but nor 2). Per your experience, what approach should I use? Thanks for your advice.

2 solutions

Solution 1

Try this link
http://stackoverflow.com/questions/1389513/converting-xml-to-a-datatable[^]
Hope this helps

Posted 5-Sep-13 3:31am

Jameel VM

Comments

shaning 5-Sep-13 9:52am

To Jameel: Thanks for your post. I tried the approach as you recommended. But I got the exception: DataTable does not support schema inference from Xml.
DataTable myDataTable = new DataTable();
System.Net.HttpWebRequest myRequest = (System.Net.HttpWebRequest)System.Net.WebRequest.Create(new Uri(url));
myRequest.Method = "GET";

System.Net.WebResponse myResponse;
try {
myResponse = myRequest.GetResponse();
using (System.IO.Stream responseStream = myResponse.GetResponseStream()) {
myDataTable.ReadXml(responseStream);
}
} catch (Exception ex) {
throw new Exception("Got an error " + ex.Message);
}
Please provide your advice if you can. Thanks.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

shaning · Accepted Answer · 2013-09-10T03:35:00

Solution 2

Problem solved - see How to convert and parse an xml file to Dataset[^][^]

Posted 10-Sep-13 3:35am

shaning