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 _
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...
dim query as something = GetMenuByMenuID(menuId)
txtMenuName.text = query.menuName
how do I do that?