/// <summary> > /// Returns a classname (string) from the passed classid (int) parameter > /// </summary> > public string GetClassName(int key) > { > // Get a reference to the data access object > mmDataAccessBase dao = this.GetDataAccessObject(); > > // Create the parameters and set the direction > IDbDataParameter param1 = dao.CreateParameter("@ClassID", key); > param1.Direction = ParameterDirection.Input; > > string classname = "trysomejunktexthere"; > > IDbDataParameter param2 = dao.CreateParameter("@ClassName",classname); > param2.Direction = ParameterDirection.Output; > > // Call the stored procedure and pass the parameters > IDbCommand cmd; > this.ExecSprocScalar("ssAPI_getClassName",out cmd, param1, param2); > > // Retrieve the value from the command object > IDbDataParameter param = (IDbDataParameter)cmd.Parameters["@ClassName"]; > string retval = param.Value.ToString(); > > return retval; > } >