Hi Mark,

The application is a monolithic program written in VB.Net 2003 by a coder
who's no longer here, and I'm coming in on his coat tails to maintain the
code, learning VB along the way.  To the best I can determine the
application creates a session with all the general information, like the
UserID, UserName, Groups, and so forth.  It then uses datasets, setup both
in the code and via the IDE, to retrieve information from the MS SQL 2005
database.

What I need now is to edit a class so it pulls in a value from an MS SQL
2005 function and stores this value in a variable to use with in the class.
Here's what I've pieced together thus far:

Private Function GetManagerID() As Integer
   Dim cn As New
SqlClient.SqlConnection(System.Configuration.ConfigurationSettings.AppSettings("MyConnectionString"))
   Dim cm As New SqlClient.SqlCommand("select dbo.ManagerFunction(" +
Me.UserID + ")", cn)
  cm.ExecuteNonQuery()
End Function

But how do I get the value from dbo.ManagerFunction(#) into a variable to
use within my application after this function is called?  Also note,
MyConnectionString is already defined in the application and stores our
connection information.

Thanks ..

Alex