PROCEDURE SetUserName >>>>LPARAMETERS cUserName >>>>PUBLIC UserName >>>>UserName = cUserName >>>>ENDPROC >>>> >>>>FUNCTION WhoIsCurrentUser >>>> RETURN UserName >>>>ENDFUNC>>>>
static void Main(string[] args) >>>> { >>>> //Set public variable when setting up the connection >>>> System.Data.OleDb.OleDbConnection myConn = ConnectionProvider.CreateConnectionForUser("Jim"); >>>> >>>> // Now see if the public variable is accessible by SP >>>> System.Data.OleDb.OleDbCommand test = new System.Data.OleDb.OleDbCommand(); >>>> test.Connection = myConn; >>>> test.CommandText = "WhoIsCurrentUser()"; >>>> string s = (string) test.ExecuteScalar(); >>>> } >>>> } >>>> >>>> >>>> static class ConnectionProvider >>>> { >>>> static public System.Data.OleDb.OleDbConnection CreateConnectionForUser(string sUser) >>>> { >>>> string connection = "Provider=VFPOLEDB.1;Data Source=Data1.dbc"; >>>> System.Data.OleDb.OleDbConnection oledb = new System.Data.OleDb.OleDbConnection(connection); >>>> oledb.Open(); >>>> >>>> System.Data.OleDb.OleDbCommand command = new System.Data.OleDb.OleDbCommand(); >>>> command.Connection = oledb; >>>> command.CommandText = "SetUserName('" + sUser + "')"; >>>> command.ExecuteNonQuery(); >>>> return oledb; >>>> } >>>> }>>>>