Datatable or generic list to return data from one layer to another ?

Question

1.00/5 (3 votes)

See more:

I am confused whether to use datatable or generic list to pass values from dal to bal and ui since the amount of data is same despite of using both datatable or generic list ?

Some posts on google says it doesn't make much difference while some says list is better over datatable ?

Please justify.........?

Also, how to implement sorting in gridview through generic list in 3 tier architecture ?
Please provide a example with steps and its explanation.

What I have tried:

sorting gridview in 3 tier architecture..............

Posted 25-Apr-17 5:28am

jayesh_n

Updated 25-Apr-17 5:58am

Add a Solution

Comments

[no name] 25-Apr-17 11:41am

I will prefer to choose generic list than DataTable but it completely depend on data you are exchanging between your different layers. You have to choose which is best suite you depending on type of your data.

1 solution

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)

F-ES Sitecore · Answer 1 · 2017-04-25T05:58:00

Solution 1

Use a generic list as it's more lightweight than a datatable and it's also strongly typed.

Posted 25-Apr-17 5:58am

F-ES Sitecore

Comments

Richard Deeming 25-Apr-17 15:20pm

It also makes life easier when you decide to add a new front-end that doesn't support DataTables - for example, .NET Core. :)