Use results from a Linq query in VB

I created a Linq function to return a query... but how do I retrieve the values of each column from the results of the query?
        Public Function GetMenuByMenuID(ByVal menuId As Integer) As Object
            Dim dc As New sssMenuDataContext
            Dim query = Nothing
            If menuId <> INVALID_ID Then
                query = (From m In dc.GetTable(Of sssMenu)() _
                                               Where m.menuId = menuId _
                                               Select m).SingleOrDefault()
            End If

            Return query

        End Function

Maybe returning "query" as an object isn't what I need to do. But what I want to do is pass in a MenuID, return a single row. Then in my codebehind, populate the form fields with the column values from the table...

like:

dim query as something = GetMenuByMenuID(menuId)
txtMenuName.text = query.menuName

how do I do that?

thanks.

LVL 2
Starr DuskkASP.NET VB.NET DeveloperAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Fernando SotoRetiredCommented:
Hi BobCSD;

You can do it this way as shown in the code snippet. When calling the function you can do it like this:

Dim menuData As sssMenu = GetMenuByMenuID(menuid)

Then use menuData variable to access the data in the row. For Example to get the menuid you would do the following:

menuData.menuid

Fernando
Public Function GetMenuByMenuID(ByVal menuId As Integer) As sssMenu
 
    Dim dc As New sssMenuDataContext
    Dim query As sssMenu = Nothing
    If menuId <> INVALID_ID Then
        query = (From m In dc.GetTable(Of sssMenu)() _
                 Where m.menuId = menuId _
                 Select m).SingleOrDefault()
    End If
 
    Return query
 
End Function

Open in new window

0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Starr DuskkASP.NET VB.NET DeveloperAuthor Commented:
perfect! thnks!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.