locked
How to get the out parameter value in Data Access Block(DAAB) 2006 RRS feed

  • Question

  • User-1196558243 posted

    The following code works well
    ------------------------------------

    Database DB = DatabaseFactory.CreateDatabase();
    DbCommand dbCmd = DB.GetStoredProcCommand("up_XXX");
    DB.AddInParameter(dbCmd, "TITLE", DbType.String, "DDDD");
    DB.AddOutParameter(dbCmd, "TotalCount", DbType.Int32, 20);

    DB.ExecuteNonQuery(dbCmd);
    int TotalCount = (int)DB.GetParameterValue(dbCmd, "TotalCount");

    ----------------------------------------------------------------

    But i want to use DB.ExecuteReader(dbCmd),not ExecuteNonQuery;
    and it does't work,i can not get any return vlaue


    int TotalCount = (int)DB.GetParameterValue(dbCmd, "TotalCount");

    how to do?

     

     

    Thursday, July 13, 2006 2:23 AM

All replies