Click here to Skip to main content
15,907,687 members
Home / Discussions / C#
   

C#

 
Questionhow to create XML using DataSet having more then one table? Pin
Sasmi_Office7-Jul-09 2:17
Sasmi_Office7-Jul-09 2:17 
Dear Friend,

I have four DataTable Name "Table 1", "Table 2", "Table 3" and "Table 4" this table contain two rows each as given below

Data in "Table 1"
ID
1
2

Data in "Table 2"
ID Name
1 ABC
2 XYZ

Data in "Table 3"
ID Date
1 01/01/2009
2 02/01/2009

Data in "Table 4"
ID Value
1 AAA
2 XXX

This all table added in one DataSet related with each other using Relations with ID Column.

Now when i create XML file using this DataSet it Gives me in sequence as given below.

<?xml version="1.0" standalone="yes" ?>
<Data Set>
<Table 1>
<ID>1</ID>
</Table 1>
<Table 1>
<ID>2</ID>
</Table 1>
<Table 2>
<Name>ABC</Name>
</Table 2>
<Table 2>
<Name>XYZ</Name>
</Table 2>
<Table 3>
<Date>01/01/2009</Date>
</Table 3>
<Table 3>
<Date>02/01/2009</Date>
</Table 3>
<Table 4>
<Value>AAA</Value>
</Table 4>
<Table 4>
<Value>XXX</Value>
</Table 4>
</Data Set>


The problem is the sequence i want the same data in following sequence
<?xml version="1.0" standalone="yes" ?>
<Data Set>
<Table 1>
<ID>1</ID>
</Table 1>
<Table 2>
<Name>ABC</Name>
</Table 2>
<Table 3>
<Date>01/01/2009</Date>
</Table 3>
<Table 4>
<Value>AAA</Value>
</Table 4>
<Table 1>
<ID>2</ID>
</Table 1>
<Table 2>
<Name>XYZ</Name>
</Table 2>
<Table 3>
<Date>02/01/2009</Date>
</Table 3>
<Table 4>
<Value>XXX</Value>
</Table 4>
</Data Set>

Is this Possible? or there is another way to do this?

Please help me.

Thanks and Regards in advance

Sasmi
AnswerRe: how to create XML using DataSet having more then one table? Pin
Dave Kreskowiak7-Jul-09 3:42
mveDave Kreskowiak7-Jul-09 3:42 
QuestionForm designer insisting on form being checked out Pin
Dan Neely7-Jul-09 2:11
Dan Neely7-Jul-09 2:11 
AnswerRe: Form designer insisting on form being checked out Pin
molesworth7-Jul-09 2:20
molesworth7-Jul-09 2:20 
GeneralRe: Form designer insisting on form being checked out Pin
Dan Neely7-Jul-09 2:31
Dan Neely7-Jul-09 2:31 
GeneralRe: Form designer insisting on form being checked out Pin
molesworth7-Jul-09 2:41
molesworth7-Jul-09 2:41 
GeneralRe: Form designer insisting on form being checked out Pin
Dan Neely7-Jul-09 3:17
Dan Neely7-Jul-09 3:17 
AnswerRe: Form designer insisting on form being checked out Pin
Christian Graus7-Jul-09 2:39
protectorChristian Graus7-Jul-09 2:39 
GeneralRe: Form designer insisting on form being checked out Pin
molesworth7-Jul-09 2:49
molesworth7-Jul-09 2:49 
GeneralRe: Form designer insisting on form being checked out Pin
Dan Neely7-Jul-09 3:06
Dan Neely7-Jul-09 3:06 
GeneralRe: Form designer insisting on form being checked out Pin
molesworth7-Jul-09 3:41
molesworth7-Jul-09 3:41 
GeneralRe: Form designer insisting on form being checked out Pin
Dan Neely7-Jul-09 4:12
Dan Neely7-Jul-09 4:12 
AnswerRe: Form designer insisting on form being checked out [SOLUTION] Pin
Dan Neely7-Jul-09 4:16
Dan Neely7-Jul-09 4:16 
GeneralRe: Form designer insisting on form being checked out [SOLUTION] Pin
molesworth7-Jul-09 5:48
molesworth7-Jul-09 5:48 
GeneralRe: Form designer insisting on form being checked out [SOLUTION] Pin
Dan Neely7-Jul-09 7:17
Dan Neely7-Jul-09 7:17 
QuestionReading word document in asp.net Pin
Spurple7-Jul-09 1:44
Spurple7-Jul-09 1:44 
AnswerRe: Reading word document in asp.net Pin
Christian Graus7-Jul-09 1:46
protectorChristian Graus7-Jul-09 1:46 
Questionmerging byt[] in c# Pin
GauravKP7-Jul-09 1:42
professionalGauravKP7-Jul-09 1:42 
AnswerRe: merging byt[] in c# Pin
Christian Graus7-Jul-09 1:48
protectorChristian Graus7-Jul-09 1:48 
AnswerRe: merging byt[] in c# Pin
DaveyM697-Jul-09 1:56
professionalDaveyM697-Jul-09 1:56 
Questiontic tak toe Pin
Mostafa&Messi7-Jul-09 0:46
Mostafa&Messi7-Jul-09 0:46 
GeneralRe: tic tak toe Pin
Pete O'Hanlon7-Jul-09 0:47
mvePete O'Hanlon7-Jul-09 0:47 
AnswerRe: tic tak toe Pin
Rajesh R Subramanian7-Jul-09 0:49
professionalRajesh R Subramanian7-Jul-09 0:49 
GeneralRe: tic tak toe Pin
OriginalGriff7-Jul-09 1:01
mveOriginalGriff7-Jul-09 1:01 
AnswerRe: tic tak toe PinPopular
Christian Graus7-Jul-09 1:08
protectorChristian Graus7-Jul-09 1:08 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.