Linq Error

Manoj Patel

13y2.2kLINQ

Hi,

I'm using Linq in Vb.net 2012
but I'm getting an error as " 'query' is not declared. It may be inaccessible due to its protection level"

how to solve this issue

Imports System.Windows
Imports System.Data
Imports System.Data.SqlClient
Imports System.Linq
Imports System.Collections.Generic

'======================================================================================================
Dim parent As DataTable = dset.Tables("magenmst")
Dim child As DataTable = dset.Tables("magengrp")

dim query   = _
            From P In parent.AsEnumerable, c In child.AsEnumerable _
            Where P.Field(Of)("agcode") = c.Field(Of )("aggrpcd") _
            Select P,c;

Dim view As DataView = query.AsDataView()
'======================================================================================================

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Iftikar Hussain13y ago
Hi,
Try like this

Dim parent As DataTable = dset.Tables("magenmst")
Dim child As DataTable = dset.Tables("magengrp")
Dim query = From P In parent, c In child _
Where P("agcode") = c("aggrpcd") _
Select P, c

Regards,
Iftikar
abhishek goletar13y ago
have you check dim query return's what?
Vulpes13y ago
I think you've declared 'query' correctly (subject to the changes I mentioned in my previous post) because it's a collection of anonymous types and so you have to leave the compiler to infer what the type is.

The type following 'Of' should of course be the type of the "agcode" and "aggrpcd" columns in the datatables.

System.Data.DataSetExtensions.dll is part of the .NET framework but it's not included in your projects by default. You therefore have to add a reference to it manually.
Manoj Patel13y ago
Hi, Thanks for your reply 'query' how to declare or type of data or object and that dll already in reference
Vulpes13y ago
It sounds to me like you haven't yet added a reference to System.Data.DataSetExtensions.dll to your project, as this is needed for the AsDataView extension method.

Also, I'd have thought that you'll need to insert the appropriate types after 'Of' and remove the semi-colon at the end of the 'query' declaration to get it to compile.