[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1427
  • Last Modified:

LINQ query to datatable

I'm using VB 2008
I want to do some Linq queries and the result convert to datatable to use in a datagridview.
If I dothe Option 1 (see the code) it works well, but I have to declare the Linq Query as a System.Data.EnumerableRowCollection(Of ..)

If I declare the Linq query as    IEnumerable it do the query well but then I can't convert it to datatable.      
''Option 1
            Dim Comp053 As System.Data.EnumerableRowCollection(Of LOGDataSet.MovRow)
            Dim tabMovFac As LOGDataSet.MovDataTable
 
            Comp053 = From f In tabMovFac.AsEnumerable _
                       Where (f.TipoFactura <> "I")
            
 
	    Dim taulaComp053 As DataTable
            taulaComp053 = New DataTable
 
            If Comp053.Count > 0 Then
                taulaComp053 = Comp053.AsEnumerable.CopyToDataTable
            End If

Open in new window

0
cpx_Support
Asked:
cpx_Support
1 Solution
 
CodeCruiserCommented:
I usually code my own methods naming them such as ShredContacts etc. Within these methods, i iterate through the query and manually create datatable. It also helps with things like adding the name of the emp who created the client rather than the ID or the object.
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now