LINQ to Dataset (VB 2102)
I am trying to implement basic examples of LINQ to Dataset
ds is an existing, full dataset (one table)
PKName is the name of a COLUMN in the table
PKValue is the value of that column
Dim dt As DataTable = ds.Tables(0)
query = _
From ele In dt.AsEnumerable() _
Where ele.Field(Of Int16)(PKName) = PKValue _
Select ele
I want now to browse through the results.
for each e in query
console.writeline(e.ele)
next e
but the compiler claims "e is not a member of System.Data.DataRow
In fact, given "e" (a row in a table) I need the columns named prefix1, prefix2, prefix3....
I am stuck on it and would appreciate any guidance.
thanks
|