How To Convert Dataset To List

Question

0.00/5 (No votes)

See more:

C#

ASP.NET

I'm trying to Convert data set with multiple Tables(i.e ds.tables.count>1) to List...Plz Any Help

Posted 27-Jan-14 23:49pm

Tharun@Chinna

Add a Solution

Comments

OriginalGriff 28-Jan-14 5:54am

What have you tried?
Where are you stuck?

Tharun@Chinna 28-Jan-14 6:08am

Hi,
Actually I tried with Data set With Single Table i.e .Tables(0). But What i'm Trying is my data set have 4 tables. i want to convert 4 tables data into single list..

OriginalGriff 28-Jan-14 6:11am

Do all the tables contain the same number and type of columns?

Tharun@Chinna 28-Jan-14 6:17am

No, All Tables Have Different Column names,type & Column.count Also Different.

OriginalGriff 28-Jan-14 6:28am

So how do you expect a single List to cope with them all? :laugh:
One way is to have a List of Lists, and allow a separate list for each table in the set - but that kind of defeats the purpose, I'm guessing!

So if they are all different, how do you propose to use the end result? Unless there is some way to tie the different tables together, it's going to be hard to work with.

Tharun@Chinna 28-Jan-14 6:40am

Thank you For Supporting Me, If U find Any Solution Plz help me.

OriginalGriff 28-Jan-14 6:43am

Supporting isn't a problem - but I don't think that you have given us enough info to actually give you "real" code.
Perhaps is you gave us an example of the tables in teh set, and what kind of thing you wanted in the final list?

Tharun@Chinna 28-Jan-14 7:03am

k. Actually I'm Trying to write a Dynamic function, I'll pass data set to that function by end i want result in List,In every time ds have different data, like table count & type

like

public List<clssbo> dstolist(ds Dataset)
{
_objects = new List<clssbo>();
'
'
'
return _objects;
}

3 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)

JoCodes · Answer 1 · 2014-01-27T23:55:00

Solution 1

Refer

http://stackoverflow.com/questions/17107220/convert-dataset-to-object-list[^]

Posted 27-Jan-14 23:55pm

JoCodes

Comments

Tharun@Chinna 28-Jan-14 6:28am

Hi,
Actually I tried with Data set With Single Table i.e .Tables(0). But What i'm Trying is my data set have 4 tables. i want to convert 4 tables data into single list.
All Tables Have Different Column names,type & Column.count Also Different.

JoCodes 28-Jan-14 6:56am

In that case you need to have List<object> type so any type can be added.

OriginalGriff · Answer 2 · 2014-01-28T01:38:00

"k. Actually I'm Trying to write a Dynamic function, I'll pass data set to that function by end i want result in List,In every time ds have different data, like table count & type

like

public List dstolist(ds Dataset)
{
_objects = new List();
'
'
'
return _objects;
}"

The trouble with trying to do that is that you can't return anything particularly intelligent: You can't assume any interconnection between the separate tables, so you end up just "attaching" each table data on the bottom of the previous one.

This may help: Convert Datatable to Collection using Generic[^]
If you follow how that works, you should be able to generate a "generic" solution for multiple tables.
I can't help thinking it's not going to be much use in practice though!

Vandana_Pathak · Answer 3 · 2014-01-28T00:09:00

Solution 3

XML

ds.fill(dt);
List&lt;DataRow&gt; list = new List&lt;DataRow&gt;();
foreach(Datarow row in dt.rows)
{
 list.add((DataRow)row);
}</datarow></datarow>

Posted 28-Jan-14 0:09am

Vandana_Pathak

Updated 28-Jan-14 0:12am

v2

Comments

Tharun@Chinna 28-Jan-14 6:27am

Hi,
Actually I tried with Data set With Single Table i.e .Tables(0). But What i'm Trying is my data set have 4 tables. i want to convert 4 tables data into single list.
All Tables Have Different Column names,type & Column.count Also Different.

How To Convert Dataset To List

3 solutions

Solution 1

Solution 4

Solution 3

Add your solution here

Preview 0

Existing Members

...or Join us