• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 358
  • Last Modified:

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.

0
Starr Duskk
Asked:
Starr Duskk
1 Solution
 
Fernando SotoCommented:
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
 
Starr DuskkASP.NET VB.NET DeveloperAuthor Commented:
perfect! thnks!
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

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