create PROCEDURE SPROC_GetTrail
    -- Add the parameters for the stored procedure here
      @AccountId INT ,
      @SchemePlanCode INT ,
      @Todate OUTPUT

END

db = DatabaseFactory.CreateDatabase("io");
                getCommissionReconMisCmd = db.GetStoredProcCommand("SPROC_GetTrail");
                db.AddINParameter(getCommissionReconMisCmd, "@Id", DbType.Int32, AId);---