how to change the Order of the Table in the Dataset?

Question

0.00/5 (No votes)

See more:

Hi,

[C#, ASP.Net]

I have a Dataset containing multiple tables. The tables are dynamically and randomly added into the dataset. If i create xml using ds.GetXml(), all the tables are converted as xml.

I need to make one of the Data Table as a First table in that xml. For eg: if i have 3 tables Addr_det, Cust_det and Cust_Income. I added these tables randomly in to the dataset [Addr_det, Cust_Income and Cust_det]. Now i need the Cust_det table should be a first table in that dataset (or xml).

Please help me....

Thanks in Advance.

Posted 28-Jun-10 3:02am

Mano-Guru

Updated 28-Jun-10 3:08am

LittleYellowBird

v2

Add a Solution

Comments

Sandeep Mewara 28-Jun-10 9:23am

Why not change the order in the dataset itself?

2 solutions

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)

Ankur^\m/ · Answer 1 · 2010-06-28T03:49:00

Solution 1

I guess you have to create another DataSet and copy tables from old DataSet to the new one in required order.

I am not sure if there is a better way for this. I will keep a watch too.

Posted 28-Jun-10 3:49am

Ankur^\m/

Prosanta Kundu online · Answer 2 · 2010-06-29T18:11:00

Solution 2

Instead of creating another copy of Dataset, you can sort the tables in xml using XQuery. This will be performance wise more faster than dataset.

Posted 29-Jun-10 18:11pm

Prosanta Kundu online

Comments

Ema112 25-Jan-17 10:06am

How to do the above??