Dataset values to store in list object

Question

0.00/5 (No votes)

See more:

DataSet values to store in List object
I have a DataSet, that needs to be passed into a list object. Name of columns in DataSet are same as properties of list object.

Example:

Data Set columns

C#

PickupCity
 PickupState
 PickupCountry

List Object Properties

C#

ContactPerson
 PickupCity
 PickupState
 PickupCountry
 PhoneNumber

I do not want to assign / define each column one by one, like:

C#

PickupCity = dr["PickupCity"].ToString(),

I am looking for something like below that automatically assign available data with same column / property name:

C#

List<PickupClass> pickup = DataSet

What I have tried:

C#

if (dataSet != null)
{
    dataTable = dataSet.Tables[0];

    _inboundDataTable = (from DataRow dr in dataTable.Rows
                         select new InboundDataTable()
                         {
                             OriginCompany = dr["OriginCompany"].ToString(),
                             OriginAddress = dr["OriginAddress"].ToString(),
                             OriginAddress2 = dr["OriginAddress2"].ToString(),

This is the part of code, which is currently implemented. Want to change it to more robust one.

Posted 4-Dec-21 3:34am

Zeeshan Dar 2021

Updated 4-Dec-21 10:11am

Add a Solution

Comments

[no name] 4-Dec-21 13:13pm

Seems redundant. Just use the data table.

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)

OriginalGriff · Answer 1 · 2021-12-04T04:00:00

Solution 1

Try this: Conversion Between DataTable and List<TSource> in C#[^]

Posted 4-Dec-21 4:00am

OriginalGriff

Zeeshan Dar 2021 · Answer 2 · 2021-12-04T10:11:00

Hi,
After searching and few adjustments, below solution worked for me.

Create helper class

C#

public static class Helper
 {
     public static List<T> DataTableToList<T>(this DataTable table) where T : class, new()
     {
         try
         {
             List<T> list = new List<T>();

             foreach (var row in table.AsEnumerable())
             {
                 T obj = new T();

                 foreach (var prop in obj.GetType().GetProperties())
                 {
                     try
                     {
                         PropertyInfo propertyInfo = obj.GetType().GetProperty(prop.Name);
                         propertyInfo.SetValue(obj, Convert.ChangeType(row[prop.Name], propertyInfo.PropertyType), null);
                     }
                     catch
                     {
                         continue;
                     }
                 }

                 list.Add(obj);
             }

             return list;
         }
         catch
         {
             return null;
         }
     }
 }

Called helper using

C#

dataTable = dataSet.Tables[0];
List<InboundDataTable> _inboundDataTable = dataTable.DataTableToList<InboundDataTable>();