xml to dataset !!

Nandor Devai
HOME » ASP & ASP.net

i use the following code to write sql data to xml file.

SqlDataAdapter ad = new SqlDataAdapter("SELECT name AS [@label], salary AS [@value] FROM Employee FOR XML PATH('set'),ROOT('chart')", cnn); cnn.Close(); DataSet ds = new DataSet("chart"); ad.Fill(ds,"set"); XmlDataDocument doc = new XmlDataDocument(ds); doc.Save(Server.MapPath(Request.ApplicationPath)+" .xml");

i get the file as

<chart><set><xml><chart><set label=""abcd value="abcd" /></chart></xml></set></chart>

i want to remove the first three tags; ie, <chart>,<set> and

Tags : xml dataset

Related to : xml to dataset !!
Is there a difference between 'valid xml' and 'well formed xml'?
by Robert M in ASP & ASP.net

I wasn't aware of a difference, but a coworker says there is, although he can't back it up. What's the difference if any?
another '<href> in XML' question
by MovingSpotlight in ASP & ASP.net

another '<href> in XML' question
1 Attachment(s)
I'm playing around with a 3D carousel. When you click on one of the carousel icons it loads some XML. I need to put a hyperlink in there. I've read a bunch of different threads on this and
What's the best way to search for help related to 'XML'?
by Monev in ASP & ASP.net

What's the best way to search for help related to 'XML'?
Hi, I tried to run search for messages re use of XML in flash. Instead I got this:
Sorry - no matches. Please try some different terms.
The following words are either very common, too long, or too short a
Modify perl 'excel to xml'
by ShiggityShaw in ASP & ASP.net

Hello everybody, I'am a new member and I need your help to modify a perl file named 'material mapping generator.pl'.
My file perl convert a excel table to material mapping .xml.
in the field "pr_family" the user can concatenate the family value in one cell like '1,2'
TAGS: Modify perl excel

"Non Zero Exit Status" R 3.0.1 'XML' and 'RCurl'
by Dré in ASP & ASP.net

I am having a bit of trouble installing XML and or RCurl on my Ubuntu machine 13.10. I performed all sudo update and upgrades today.I am trying to use rattle for R. I am unable to install 'XML' which is required for the use of rattle. This is pretty much the same question that was asked right here j
A good definition of the term 'var xml'?
by GregoryWE in ASP & ASP.net

A good definition of the term 'var xml'?
I've to leave a few comments in my AS3 coding but I can't think of a good definition to write for 'var xml'. I know it's basic but it's catching me out.

unable to bind to property '****' on class 'XML'
by akr in ASP & ASP.net

unable to bind to property '****' on class 'XML'
Hi everyone
I've tried to copy/drag data from a tilelist to a datagrid with the data format as xml/xmlcollectionlist.
Inside the tilelist, i displayed each element from the dataprovider(XML), but after i compiled
'Code Notes for XML' Book Review
by Flapdrol1337 in ASP & ASP.net

Has anyone used this book before?
I just bought it at a discoutn book store, and i couldn't pass it up for the price. I know the money probably isn't wasted, but will my time be wasted?
Also, i've seen that this is a series of books, are they worth while?
The file 'devices.xml' containing the device SDK configuration could not be found
by weenerdog in ASP & ASP.net

I've installed SDK 1.1 with QT Creator. I want to create some simple application for Symbian S60 3rd FP1, but I don't have anything in SDK S60 tab, and I get
[QUOTE]The file 'devices.xml' containing the device SDK configuration could not be found looking at the registry key HKEY_LOC
Application package 'AndroidManifest.xml' must have a minimum of 2 segments
8/12/2014 10:20 pm by Matt Willtrout in ASP & ASP.net

I read this:
Error in AndroidManifest.xml "must have a minimum of 2 segments" but there is no solution.

Its happen after I change the name of the pr

HD Wallpapers
3D Abstract
Indian Celebrities
Animals Birds
Black White
Food Drink
Dreamy Fantasy
Bikes Motorcycles
Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .