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

Hello,
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
3D Abstract
City
Celebrities
Indian Celebrities
Cars
Travel
Girls
Animals Birds
Movies
Sports
Black White
Nature
Planes
Anime
Food Drink
Dreamy Fantasy
Architecture
Games
Space
Holidays
Flowers
Love
Artistic
Baby
Beach
Bikes Motorcycles
Macro
Computers
Vector
Funny
Army
Textures
Brands
Misc
Music
Other
Privacy Policy - Copyrights Notice - Feedback - Report Violation - RSS 2017 © bighow.org All Rights Reserved .