How to copy the Linq result value to DataTable

Question

0.00/5 (No votes)

See more:

Hi,

I am having a linq select query I want to copy that result to a datatable. In this the copytoDataTable is not coming. I am selecting the column value from the grdiview which is selected by using the linq query. How to copy this one to Datatable.

C#

var result = (from GridViewRow msgRow in grdPrice.Rows
                    let ReferenceNO = ((HiddenField)msgRow.FindControl("hfReferenceNo")).Value
                    where ((CheckBox)msgRow.FindControl("chkSelect")).Checked
                     select new { ReferenceNO }).ToList();

Thanks

Posted 31-Jan-14 22:43pm

Member 7946563

Add a Solution

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 · 2014-01-31T22:48:00

Solution 1

Your result is a List (since you called ToList on the IEnumerable) - so you can use this: Converting a List to a DataTable[^].
If it wasn't, then you'd have to change the code in the Tip a small amount to make it IEnumerable<T> instead of IList<T>

Posted 31-Jan-14 22:48pm

OriginalGriff

SP HINGU · Answer 2 · 2014-01-31T22:56:00

Try This

C#

public static class HelperFunctions
   {
       public static void Map<T>(this IEnumerable<T> source, Action<T> func)
       {
           foreach (T i in source)
               func(i);
       }

       public static DataTable ToDataTable<T>(this IEnumerable<T> source)
       {
           var dt = new DataTable();
           var properties = typeof(T).GetProperties();
           dt.Columns.AddRange(properties.Select(x => new DataColumn(x.Name, x.PropertyType)).ToArray());
           source.Select(x => dt.NewRow().ItemArray = properties.Select(y => y.GetValue(x, null)).ToArray()).Map(x => dt.Rows.Add(x));
           return dt;
       }
   }